Re: How do I assign Oracle pakage variable's value to aphp variable?

Hello! Hasn't anyone got this working ? "Prince Kumar" <pkumar@intacct.com> wrote in message news:EFEIJABDFCGHOMMDIGBGGEKDCDAA.pkumar@intacct.com... > 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 > >