Where are Predefined ORACLE PL/SQL Exceptions?

Where can I find Full list of all Predefined ORACLE PL/SQL Exceptions?

I have looked at that SQLCODE:-942 and SQLCODE:-02289 are exception code for sequence and table not existed. but whatever I cannot find any official document to explain the above two error code. so question is are these oracle Predefined exceptions? because I want to use the two error code to catch this two type exceptions.

Views: 26

Reply to This

Replies to This Discussion

You used the term 'exceptions', but it looks like you're asking about error code values, and specifically SQLCODEs. I'll try to answer both questions. :-)

To find the pre-defined exceptions defined in the database you can look in the package SYS.STANDARD. This is where the standard exceptions, such as NO_DATA_FOUND and TOO_MANY_ROWS, are defined. This is a good place to look if you're interested in trapping a specific SQLCODE as it might save you having to define a custom exception and initializing it with PRAGMA EXCEPTION_INIT.

To find a complete list of error code values, including SQLCODEs, compiler errors, etc, you should look in the version of the Oracle Database Error Messages manual for the database version you're using. In his reply above, @Mat gives a reference to the 11.1 manual. The 11.2 manual can be found here.

Share and enjoy.

Reply to Discussion


Oracle Jobs in US

© 2023   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service