Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RAISE_APPLICATION_ERROR
Anyone has an idea as to where this PROCEDURE
RAISE_APPLICATION_ERROR (number,'mesg') would print the message.
The serveroutpt flag is set.
When this procedure is invoked from within a function, it does not print the message anywhere.
When invoked from SQL prompt this is what happens!
SQL> execute raise_application_error(-20001,'hi') begin raise_application_error(-20001,'hi'); end; * ERROR at line 1: ORA-20001: hi ORA-06512: at line 1
Anything wrong with the above code?
Thanks
--
Nandakumar
Systems Analyst
New York
(N.Kumar_at_rocketmail.com)
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Jul 29 1999 - 13:52:17 CDT