Accessing Oracle DBMS_OUTPUT from PHP
| From: | Robert Mena | Date: | Mon, 04 Feb 2002 23:28:31 +0000 |
| Subject: | Accessing Oracle DBMS_OUTPUT from PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-83491@lists.php.net to get a copy of this message | ||
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