Oracle Log Procedure

In example below is shown how to create oracle log procedure and how to call procedure from the main procedure or function.

Note line of code  PRAGMA AUTONOMOUS_TRANSACTION in oracle log procedure (oracle_log_procedure). Procedure with this line of code can do operations COMMIT and ROLLBACK without influence on data in the main procedure or function.

EXAMPLE:

1. Create table CC_LOG:

2. Create sequence CC_LOG_SEQ:

3. Create oracle log procedure:

4. How to call oracle log procedure: