Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

Understanding Different Exception Types

Identifying Exception Types Error Code PrefixIndicates This Exception Type of Error ORACore RDBMS errors PLSPL/SQL errors FRMOracle Forms errors REPOracle Reports errors Oracle function SQLCODE returns the type and code of the most recently raised exception. Exception names are usually associated with exceptions that you create yourself. The exception message is a text string that describes the exception. The function SQLERRM returns the text of the error message for the most recently raised exception.