php.net |  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 you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
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;");
ora_bind($c,"z",":z",80,2);
ora_exec($c);
return $z;
}

echo test();

result :
4

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

Patches

Pull Requests

History

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-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 23:01:28 2024 UTC