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
 [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 10:01:29 2024 UTC