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

One problem is that there is no real sense in which you could ever generate "all" messges. A couple reasons:

1. The only messages that are ever relevant are those for which you have the products installed.
2. Some of the messages are completed at runtime and only have placesavers. If you want to see the raw messages then just have a counter that counts from 1 to 99999 and pass the value to sqlerrm() in pl/sql, but I doubt that you would be happy with the results.

Ken

Thomas Kyte wrote:
>
> 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 - 20:27:57 CDT