[PHP] How do I retrieve (assign) oracle package variable's value into a php variable?

[Prince]

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,




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php