Re: How can I generate all Oracle DBMS error messages and store in a table through PL/SQL?

A copy of this was sent to armaghan_at_usa.net (if that email address didn't require changing) On Sun, 27 Jun 1999 13:13:49 GMT, you wrote:

>Hi, dear friends,
>
>How can I generate all Oracle DBMS error messages and store in a table
>through PL/SQL?
>
>Thanks and best regards,
>M. Armaghan Saqib (armaghan_at_geocities.com)
>SQL Link for XL 1.5. A free tool to integrate Databases with XL.
>http://www.geocities.com/WallStreet/Floor/8484/
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

They are already there:

SQL> exec dbms_output.put_line( sqlerrm( -1403 ) ); ORA-01403: no data found

PL/SQL procedure successfully completed.

sqlerrm returns the last error you encountered OR if you pass it an error code -- it gives you the error text for that message.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Jun 27 1999 - 09:04:46 CDT