Logging in PL/SQL that survives ROLLBACK (and 4 mistakes to avoid)
You get a call: last night's batch failed, the transaction rolled back, and now someone asks "what happened?" You open your log table. It's empty. I…
Tech news from the best sources
You get a call: last night's batch failed, the transaction rolled back, and now someone asks "what happened?" You open your log table. It's empty. I…
1. Overview & Core Concepts Definition: A pseudo-column behaves like a table column, but it is not actually stored on disk in the table. Capabil…
An Exception is a PL/SQL runtime error condition triggered during code execution. When an exception is raised, normal execution of the current PL/SQ…