RE: [PHP-DB] How do I assign Oracle pakage variable's value to aphp variable?

I was thinking the same. But I believe there should be a better way. (We do't want to pass the package variables as OUT variable in a procedure or return them from function, if there are many) I tried this, $sth = OCIParse ( $dbh, "begin :myval := mypkg.my_pkg_var; end;"); OCIBindByName ( $sth, ":myval", $my_val, 10 ); But, didn't work. May be some one here has the solution. Let me know, if you find any goood solution. Thanks, -----Original Message----- From: Paul Edmondson [mailto:paul@yospace.com] Sent: Tuesday, April 30, 2002 3:52 AM To: Prince Cc: php-db@lists.php.net Subject: Re: [PHP-DB] How do I assign Oracle pakage variable's value to aphp variable? What a good question. I've just had a quick look around the API and I think the only way would be to write a stored function to return the value. I could not find any functions to bind to those types of values without the stored functions. Have you had any other ideas on how to achieve this? Or even found the solution? On Mon, 2002-04-29 at 20:59, Prince wrote: > 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 ; > / > > Thanks, > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- ------------------------------------------------------------ Paul Edmondson, Software Engineer Yospace: Creating Value for Wireless 7 The Courtyard, High Street, Staines, UK, TW18 4DR Tel: +44 1784 466388 Fax: +44 1784 466387 http://www.yospace.com