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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: minetto at unochapeco dot rct-sc dot br
New email:
PHP Version: OS:

 

 [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

Add a Patch

Pull Requests

Add a Pull Request

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: Fri Apr 26 11:01:31 2024 UTC