Oracle Database Errors or Warnings from Error ORA-25021 to ORA-25030

SQLServerF1

ORA-25021: cannot reference a trigger defined on another table
Cause: Referenced trigger in the FOLLOWS clause was defined on another table.
Action: Create the referenced trigger on the same table
ORA-25022: cannot reference a trigger of a different type
Cause: Referenced trigger in the FOLLOWS or PRECEDES clause was either a different type or not a compound trigger.
Action: Create the referenced trigger as the same type or a compound trigger.
ORA-25023: Cyclic trigger dependency is not allowed
Cause: A cycle of trigger dependency can be formed.
Action: Do not create a trigger that can formed a cyclic dependency.

ORA-25024: cannot specify FOLLOWS for a REVERSE CROSSEDITION trigger
Cause: The FOLLOWS clause was specified when creating the REVERSE CROSSEDITION trigger.
Action: Do not create a REVERSE CROSSEDITION trigger with a FOLLOWS clause.
ORA-25025: cannot specify PRECEDES clause
Cause: The PRECEDES clause was specified when creating a FORWARD CROSSEDITION trigger or a regular trigger.
Action: Do not create a FORWARD CROSSEDITION or a regular trigger with a PRECEDES clause.
ORA-25026: FOR EACH ROW was specified with compound triggers
Cause: FOR EACH ROW is not allowed with compound triggers.
Action: Remove the FOR EACH ROW clause.

ORA-25027: compound triggers cannot be used as system triggers
Cause: Compound trigger was defined as system trigger.
Action: Do not use compound trigger as system trigger.
ORA-25028: regular trigger body can not start with keyword COMPOUND
Cause: Regular triggers body should start with BEGIN/DECLARE etc .
Action: Fix the syntax and recompile.
ORA-25029: compound triggers should always start with keyword COMPOUND
Cause: Compound trigger body was started with incorrect keyword.
Action: Fix the syntax and recreate.
ORA-25030: crossedition trigger cannot be created by a non-editioned user
Cause: An attempt was made to create crossedition trigger by a non-editioned user.
Action: Enable editions for the user and then create the crossedition trigger.

Above are list of Oracle Database Errors or Warnings from Error ORA-25021 to ORA-25030 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.

Thanks,
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 *