Oracle Database Errors or Warnings from Error ORA-04071 to ORA-04080



ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword
Cause: The trigger statement is missing the BEFORE/AFTER/INSTEAD OF clause.
Action: Specify either BEFORE, AFTER or INSTEAD OF.
ORA-04072: invalid trigger type
Cause: An invalid trigger type was given.
Action: Specify either INSERT, UPDATE or DELETE.
ORA-04073: column list not valid for this trigger type
Cause: A column list was specified for a non-update trigger type.
Action: Remove the column list.

ORA-04074: invalid REFERENCING name
Cause: An invalid name was given in the referencing clause.
Action: Verify the referencing name is not a reserved word.
ORA-04075: invalid trigger action
Cause: An statement was given for the trigger action.
Action: Re-specify the trigger action.
ORA-04076: invalid NEW or OLD specification
Cause: An invalid NEW or OLD specification was given for a column.
Action: Re-specify the column using the correct NEW or OLD specification.

ORA-04077: WHEN clause cannot be used with table level triggers
Cause: The when clause can only be specified for row level triggers.
Action: Remove the when clause or specify for each row.
ORA-04078: OLD and NEW values cannot be identical
Cause: The referencing clause specifies identical values for NEW and OLD.
Action: Re-specify either the OLD or NEW referencing value.
ORA-04079: invalid trigger specification
Cause: The create TRIGGER statement is invalid.
Action: Check the statement for correct syntax.
ORA-04080: trigger ‘string’ does not exist
Cause: The TRIGGER name is invalid.
Action: Check the trigger name.

Above are list of Oracle Database Errors or Warnings from Error ORA-04071 to ORA-04080 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *