Oracle Database
PL/SQL SELECT INTO raises NO_DATA_FOUND when no row matches. The correct behavior depends on whether the business operation permits absence.
SQL & PL/SQL Errors2 min read
Read article : ORA-01403: decide whether no data is an error or an expected result
Oracle Database
A PL/SQL exact fetch assumes a single row. A broader predicate or duplicate business key can violate that assumption after data growth.
SQL & PL/SQL Errors2 min read
Read article : ORA-01422: repair an exact fetch that returned too many rows
Oracle Database
A value can exceed a variable's capacity or fail conversion inside PL/SQL even when its source query succeeds. Preserve the full runtime backtrace.
SQL & PL/SQL Errors2 min read
Read article : ORA-06502: locate a PL/SQL value or conversion error
Oracle Database
A view or program unit may become invalid after a dependency or privilege changes. Retrieve its actual compiler errors before recompiling repeatedly.
SQL & PL/SQL Errors2 min read
Read article : ORA-04063: inspect compilation errors in an invalid object
Oracle Database
A session holding package state can fail after a package is recompiled or invalidated. Connection pools may keep such sessions alive across a release.
SQL & PL/SQL Errors2 min read
Read article : ORA-04068: understand discarded package state after deployment
Oracle Database
A value that fits by visible characters may exceed a byte-limited column when multibyte text is stored. Inspect the destination's length semantics.
SQL & PL/SQL Errors1 min read
Read article : ORA-12899: compare character length with byte capacity
Oracle Database
On Oracle 19c, a very large expression list can exceed the SQL limit. Capturing how the application generates the predicate is more useful than increasing statement text length.
SQL & PL/SQL Errors1 min read
Read article : ORA-01795: replace an oversized IN list with a scalable design
Oracle Database
A report can fail when a new selected expression is neither grouped nor aggregated. Review the query's intended grain rather than adding every column mechanically.
SQL & PL/SQL Errors2 min read
Read article : ORA-00979: align SELECT expressions with GROUP BY
Oracle Database
An application can appear frozen while waiting for another transaction. Locate the waiter and its reported blocker before choosing a recovery action.
Sessions, Locks & Transactions2 min read
Read article : Identify an Oracle blocking session before terminating anything
Oracle Database
A deadlock is a cycle of conflicting resources, not simply a slow lock. Oracle reports an error to break the cycle and records diagnostic detail.
Sessions, Locks & Transactions2 min read
Read article : ORA-00060: use the deadlock trace to fix transaction ordering
Oracle Database
A schema change or NOWAIT operation may fail because another session owns a conflicting lock. Identify the operation and object before rescheduling.
Sessions, Locks & Transactions2 min read
Read article : ORA-00054: investigate a resource busy during DDL or NOWAIT access
Oracle Database
A WAIT-based operation can time out while another transaction holds the required resource. Preserve the timeout and transaction context.
Sessions, Locks & Transactions1 min read
Read article : ORA-30006: investigate a bounded lock wait that expired