常用EXCEPTION

 

 

Error Code Prefix	Indicates This Exception Type of Error
ORA	Core RDBMS errors
PLS	PL/SQL errors
FRM	Oracle Forms errors
REP	Oracle Reports errors

 

no_data_found	Singleton SELECT statement returned no data.
too_many_rows	Singleton SELECT statement returned more than one row of data.
invalid_cursor	Illegal cursor operation occurred.
value_error	Arithmetic, conversion, or truncation error occurred.
invalid_number	Conversion of a number to a character string failed.
zero_divide	Attempted to divide by zero.
dup_val_on_index	Attempted to insert a duplicate value into a column that has a unique index.
cursor_already_open	Attempted to open a cursor that was previously opened.
not_logged_on	A database call was made without being logged into Oracle.
transaction_backed_out	Usually raised when a remote portion of a transaction is rolled back.
login_denied	Login to Oracle failed.
program_error	If PL/SQL encounters an internal problem.
storage_error	If PL/SQL runs out of memory or if memory is corrupted.
timeout_on_resource	Timeout occurred while Oracle was waiting for a resource.
others	For all of the rest.