// Oracle error reference

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
Error message
error during execution of trigger ' string.string '

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_ERROR the trigger uses to enforce a rule.
  • An invalid trigger after a change to an object it uses.

How to fix it

  1. 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';
  2. 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

More pl/sql errors

The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.

// fewer errors, faster fixes

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.