Oracle Database
Character data compared with a number can trigger conversion errors when a nonnumeric value is encountered. Inspect datatypes before changing session formatting.
SQL & PL/SQL Errors2 min read
Read article : ORA-01722: find an unintended numeric conversion
Oracle Database
A date literal can work in one session and fail in another because language or date-format assumptions differ. Capture the affected session's NLS settings.
SQL & PL/SQL Errors1 min read
Read article : ORA-01843: diagnose a date string with an invalid month
Oracle Database
An explicit date conversion can still fail when the supplied string differs from its format model. Reproduce with a harmless typed example.
SQL & PL/SQL Errors1 min read
Read article : ORA-01861: match date literals to their format model
Oracle Database
An insert can omit a required value or obtain NULL through a trigger or application transformation. Identify the named column in the complete error.
SQL & PL/SQL Errors1 min read
Read article : ORA-01400: trace a NULL reaching a required column
Oracle Database
A duplicate-key error can reflect a retry, incorrect identifier generation or a genuine business duplicate. Identify the constraint before deleting data.
SQL & PL/SQL Errors2 min read
Read article : ORA-00001: identify the violated unique key
Oracle Database
A child insert or update can fail when its referenced parent does not exist in the transaction's visible data. Identify the foreign key and referenced constraint.
SQL & PL/SQL Errors2 min read
Read article : ORA-02291: investigate a missing parent key
Oracle Database
A parent deletion may be blocked because related rows still exist. Determine the business relationship before suggesting cascading deletion.
SQL & PL/SQL Errors1 min read
Read article : ORA-02292: handle dependent child records before a parent delete
Oracle Database
A query that expects one lookup value can fail when data or joins produce multiple candidates. Verify the business uniqueness assumption.
SQL & PL/SQL Errors2 min read
Read article : ORA-01427: investigate a scalar subquery returning several rows
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