php3-list | 200003

[PHP3] How to call a function of oracle from php From: Jennifer Zhou (jfzhou <email protected>)
Date: 03/10/00

Hi,

I wrote an oracle function like :

CREATE OR REPLACE FUNCTION Test RETURN varchar2
IS
 v_temp varchar2(12);
BEGIN
    select 'hello' into v_temp from dual;
 return v_temp;
END Test;

But how can I call it from php program? I use

 $stmt = OCIParse($nDBConn,"begin Test;end;");
 echo ("<p>stmt is $stmt</p>\n");
 $ret=OCIExecute($stmt);
 echo ("<p>ret is $ret</p>\n");

Where to put the return variable? 

--
Jennifer Zhou
Flag Holder New Technology Co.,Ltd.
Tel: (8621) 64672285 * 8003
Fax: (8621) 64672284
Email: jfzhou <email protected>
Web: www.gamenow.net

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>