php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #24675 Error in OCINewCursor();
Submitted: 2003-07-16 07:34 UTC Modified: 2003-07-21 01:28 UTC
From: minetto at unochapeco dot rct-sc dot br Assigned:
Status: No Feedback Package: OCI8 related
PHP Version: 4CVS-2003-07-16 (stable) OS: Linux
Private report: No CVE-ID: None
 [2003-07-16 07:34 UTC] minetto at unochapeco dot rct-sc dot br
Description:
------------
When i use the function OCINewCursor() a error happen and the server cannot execute the script.

Reproduce code:
---------------
$db=ocilogon("user","pass","db");
$curs = OCINewCursor($db);

$cod_empresa = 15;
$codAcervo = 154173;

$stmt = OCIParse($db,"begin sp_per_consulta_obra($cod_empresa
,$codAcervo,:reg_sql);end;");
ocibindbyname($stmt,":reg_sql",&$curs,-1,OCI_B_CURSOR);
ociexecute($stmt);
ociexecute($curs);
if(OCIFetchInto($curs,&$reg_sql,OCI_ASSOC))
{
        echo "ok";
}
else 
{ 
        echo "error";
}

Expected result:
----------------
Show the data in tables.

Actual result:
--------------
If i comment the line : $curs = OCINewCursor($db); 
the page is found. The error seems to be in OCINewCursor.
My info :
php version is php4-STABLE-200307142330
Oracle Client is 9.2,
apache is apache-2.0.45-28790U90_2cl



Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-07-16 14:27 UTC] sniper@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php

Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.

GDB backtrace, nothing else.

 [2003-07-21 01:28 UTC] sniper@php.net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Wed Dec 04 04:01:29 2024 UTC