php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #36096 OCI_Result() was broken data, after non checked OCI_Fetch() is executed
Submitted: 2006-01-20 08:31 UTC Modified: 2006-01-20 12:02 UTC
Votes:2
Avg. Score:5.0 ± 0.0
Reproduced:2 of 2 (100.0%)
Same Version:2 (100.0%)
Same OS:2 (100.0%)
From: t_murata at neocortex dot co dot jp Assigned: tony2001 (profile)
Status: Closed Package: OCI8 related
PHP Version: 5.1.2 OS: Linux
Private report: No CVE-ID: None
 [2006-01-20 08:31 UTC] t_murata at neocortex dot co dot jp
Description:
------------
Sorry. I am not a good English-speaking. 

OCI_Result() was broken data, after non checked OCI_Fetch() is executed.

Previous version (PHP 5.1.1) doesn't produce this broken data.


Reproduce code:
---------------
<?php
$con = OCI_Connect('usr', 'pwd', 'orasid');
$out = '';
if($con != false){
  // SQL Code
  $sql = 'SELECT \'ABC\' FROM DUAL WHERE 1<>1';
  $stmt = OCI_Parse($con, $sql);
  if(OCI_Execute($stmt, OCI_COMMIT_ON_SUCCESS)){
    OCI_Fetch($stmt);
    $out = OCI_Result($stmt, 1);
    OCI_Free_Statement($stmt);
  }
  OCI_Close($con);
}
var_dump($out);
?>


Expected result:
----------------
NULL

Actual result:
--------------
string(3) "CT " 
...etc.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-01-20 09:23 UTC] sniper@php.net
Assigned to the maintainer.
 [2006-01-20 12:02 UTC] tony2001@php.net
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Nov 21 08:01:29 2024 UTC