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.