How do I retrieve (assign) oracle package variable's value into a php variable?
| From: | Prince | Date: | Thu, 02 May 2002 00:22:56 +0000 |
| Subject: | How do I retrieve (assign) oracle package variable's value into a php variable? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-95629@lists.php.net to get a copy of this message | ||
Hello,
I have a package like the following one.
creare or replace package my_pkg as
my_pkg_var varchar(10) defalut 'myVal';
end my_pkg ;
Now, I want to read this value into a php variable (say $my_php_var). How do
I do this?
in PL/SQL, I can easily do this as
declare
tmp varchar2(10);
begin
tmp := my_pkg.my_pkg_var ;
end ;
/
I tried this,
$sth = OCIParse ( $dbh, "begin :myval := mypkg.my_pkg_var; end;");
OCIBindByName ( $sth, ":myval", $my_val, 10 );
But, didn't work. Any ideas?.
Thanks,