Oracle Error Resolution
00001 - Avoiding Unique Constraint Violation With Trigger (ORA-00001) 

00257 - Database Archiver (Server Space) Error (ORA-00257)

00603 - Oracle Server Session Terminated by fatal error (ORA-00603)

01436 - Hierarchical Query: CONNECT BY loop in user data (ORA-01436) 

01555 - snapshot too old: rollback segment number .... too small (ORA-01555) 

01790 - Expression (datatype) mismatch error (ORA-01790) 

02287 - Error in sequence call (ORA-02287)

04030 - OS Cannot Allocate Adequate PGA Memory (ORA-04030)

-- Oracle 11g and higher

54013 - INSERT operation disallowed on virtual columns 

SELECT sys.standard.sqlerrm(-level) sql_errm
FROM DUAL CONNECT BY level <= 20;

Oracle Error Listing Query (first 20 errors shown in the query)



Oracle PL/SQL Error Logging

Oracle PL/SQL Exception Handling

Oracle registered trademark of Oracle Corporation.

Last Revised On: November 04th, 2015

  23602