#24675 [Opn->Fbk]: Error in OCINewCursor();

From: Date: Wed, 16 Jul 2003 12:36:27 +0000
Subject: #24675 [Opn->Fbk]: Error in OCINewCursor();
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-44123@lists.php.net to get a copy of this message 
 ID:               24675
 Updated by:       derick@php.net
 Reported By:      minetto at unochapeco dot rct-sc dot br
-Status:           Open
+Status:           Feedback
 Bug Type:         OCI8 related
 Operating System: Linux
 PHP Version:      4CVS-2003-07-16 (stable)
 New Comment:

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.


Previous Comments:
------------------------------------------------------------------------

[2003-07-16 07:34:52] 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




------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=24675&edit=1

Thread (4 messages)

« previous php.bugs (#44123) next »