|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #752 Bind on local variables
Submitted: 1998-09-18 05:57 UTC Modified: 1999-03-30 01:48 UTC
From: bruyno dot pennec at der dot edf dot fr Assigned: thies (profile)
Status: Closed Package: Oracle related
PHP Version: 3.0.3 OS: solaris 2.5
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.
Bug Type:
From: bruyno dot pennec at der dot edf dot fr
New email:
PHP Version: OS:


 [1998-09-18 05:57 UTC] bruyno dot pennec at der dot edf dot fr
When local variables are used to bind  into PL/SQL variables, 
ora_bind accept, but when ora_exec try to copy the results
into PHP variables, it fails.

exemple :
$c is a valid Oracle cursor;
test1 is Oracle function which

function test () {
global $c;
$z = 4;
ora_parse($c,"begin :z := 3; end;");
return $z;

echo test();

result :

echo "11.2 => y=".test2()."<br>\n";


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [1999-03-30 01:48 UTC] thies
Local variables are kept on a separate stack, that is not searched
by ora_exec(). 
this works with the new OCI8 driver
check the docs for OCIBindByName

i'm not sure that we will change the oci7(ora_???) interface to support this...

PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Sun Sep 26 19:03:36 2021 UTC