常用EXCEPTION
?
?
Error Code PrefixIndicates This Exception Type of ErrorORACore RDBMS errorsPLSPL/SQL errorsFRMOracle Forms errorsREPOracle 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.?
?
???
? ?