Hasn't anyone got this working ?
"Prince Kumar" <[EMAIL PROTECTED]> wrote in message
> 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.
> -----Original Message-----
> From: Paul Edmondson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 30, 2002 3:52 AM
> To: Prince
> Cc: [EMAIL PROTECTED]
> 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
> 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).
> > 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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php