ORA-04088: error during execution of trigger
A trigger raised an error while running. The real error is listed with it in the stack; this one names the trigger as SCHEMA.TRIGGER.
- Error code
ORA-04088- Category
- PL/SQL
What it means
ORA-04088 wraps an error that happened inside a trigger, telling you which trigger it was, for example ORA-04088: error during execution of trigger 'APP.ORDERS_BIU'. The error above or below it in the stack (an ORA-06512 line and the original error) says what went wrong.
Common causes
- Any error inside the trigger body, such as ORA-01403, ORA-04091 or a
RAISE_APPLICATION_ERRORthe trigger uses to enforce a rule. - An invalid trigger after a change to an object it uses.
How to fix it
-
Read the accompanying errors and look at the trigger's code.
SELECT trigger_body FROM all_triggers WHERE owner = 'APP' AND trigger_name = 'ORDERS_BIU';
-
Fix the data or the trigger. To test whether the trigger is the cause, an administrator can disable it temporarily.
ALTER TRIGGER app.orders_biu DISABLE;
Related errors
ORA-04091table is mutating, trigger may not see itORA-06512at line (PL/SQL error stack)SQLITE_CONSTRAINT_TRIGGERSQLite: RAISE() in a trigger aborted it
More pl/sql errors
ORA-01403no data foundORA-01422exact fetch returns more than requested rowsORA-06502PL/SQL: numeric or value errorORA-06550PL/SQL compilation error at line, columnORA-06508PL/SQL: could not find program unit being calledORA-06503PL/SQL: function returned without valueORA-04068existing state of packages has been discarded
The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.
Work on Oracle in SQLly
A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.