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:[EMAIL PROTECTED]] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
