Re: How do I assign Oracle pakage variable's value to a php variable?
| From: | Paul Edmondson | Date: | Tue, 30 Apr 2002 10:52:25 +0000 |
| Subject: | Re: How do I assign Oracle pakage variable's value to a php variable? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18898@lists.php.net to get a copy of this message | ||
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