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
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
44 - 20 = ?
Subscribe to this entry?

 
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2021 The PHP Group
All rights reserved.
Last updated: Sat Jan 23 15:01:23 2021 UTC