RE: [PHP] Accessing Oracle DBMS_OUTPUT from PHP
| From: | Rudolf Visagie | Date: | Tue, 05 Feb 2002 05:55:31 +0000 |
| Subject: | RE: [PHP] Accessing Oracle DBMS_OUTPUT from PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-83537@lists.php.net to get a copy of this message | ||
Hi,
I don't think PHP can pick up responses from the DBMS_OUTPUT object; it only
picks up raised errors. Speaking under correction though.
-----Original Message-----
From: Robert Mena [mailto:rt_mena@yahoo.com]
Sent: Tuesday, February 05, 2002 1:29 AM
To: php mailing list
Subject: [PHP] Accessing Oracle DBMS_OUTPUT from PHP
Hi,
I have developed some php scripts to interact to an
oracle db using a set of predefined stored procedures
(which I did not write).
Those procedures are called either by a desktop delphi
application and my php scripts
(linux+apache+mod_php...).
I'd like to know how can I access the contents of
DBMS_OUTPUT so I can echo the custom error messages ?
A fragment of code of the actual procedure
IF (vmINT_QtdLines <= 0) THEN
DBMS_OUTPUT.PUT_LINE('NOTHING FOUND UNDER
THIS ID.');
RAISE MyError;
END IF;
Calling from delphi it shows the custom message, under
php it only shows the ORAXXXX .....
Any ideas ?
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php