Error logging - Oracle Database Full Tutorial

Start

Start
Error logging when writing to database Create Oracle error log table ERR$_EXAMPLE for existing EXAMPLE table: `EXECUTE DBMS_ERRLOG.CREATE_ERROR_LOG('EXAMPLE', NULL, NULL, NULL, TRUE);` Make writing operation with SQL: `insert into EXAMPLE (COL1) values ('example') LOG ERRORS INTO ERR$_EXAMPLE reject limit unlimited;`

Error logging when writing to database

Create Oracle error log table ERR$_EXAMPLE for existing EXAMPLE table:

EXECUTE DBMS_ERRLOG.CREATE_ERROR_LOG('EXAMPLE', NULL, NULL, NULL, TRUE);

Make writing operation with SQL:

insert into EXAMPLE (COL1) values ('example') 
LOG ERRORS INTO ERR$_EXAMPLE reject limit unlimited;

Read Article
https://develop.horje.com/learn/1434/reference