Re: Gurus, anyone give me a example for excute a PL/SQL block with php oci8 fuctions?
| From: | thies at digicol dot de | Date: | Thu, 06 Jul 2000 11:03:17 +0000 |
| Subject: | Re: Gurus, anyone give me a example for excute a PL/SQL block with php oci8 fuctions? | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-23692@lists.php.net to get a copy of this message | ||
hi,
the attached sample does call a stored proc which returns a
refcursor (so it's "complicated").
analyze it, read the manual - and your should be able to
write your own...
tc
On Tue, Jul 04, 2000 at 12:17:11PM -0700, Eric Wang wrote:
> hi, guys!
> anybody can help me?
> I need excute a Oracle PL/SQL block in php4 with oci8 fuctions,
> but I couldn't make the thing right, and could find the relevant manual
> nowhere, any goru give me a short example?
>
>
> --
> PHP Development Mailing List <http://www.php.net/>
> To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net
> For additional commands, e-mail: php-dev-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
Digital Collections Phone +49 40 235350 Fax +49 40 23535180
Hammerbrookstr. 93 20097 Hamburg / Germany
Attachment: [application/x-httpd-php] refcurs.php
CREATE OR REPLACE PACKAGE info AS TYPE the_data IS REF CURSOR RETURN all_users%ROWTYPE; PROCEDURE output(return_data IN OUT the_data); END info; / CREATE OR REPLACE PACKAGE BODY info AS PROCEDURE output(return_data IN OUT the_data) IS BEGIN OPEN return_data FOR SELECT * FROM all_users; END output; END info; /
Attachment: [application/x-httpd-php] refcurs.php
CREATE OR REPLACE PACKAGE info AS TYPE the_data IS REF CURSOR RETURN all_users%ROWTYPE; PROCEDURE output(return_data IN OUT the_data); END info; / CREATE OR REPLACE PACKAGE BODY info AS PROCEDURE output(return_data IN OUT the_data) IS BEGIN OPEN return_data FOR SELECT * FROM all_users; END output; END info; /