ORA-30505: system triggers should not reference a column in
a WHEN clause



ORA-30505: system triggers should not reference a column in a WHEN clause..

Answer / guest

Cause: An attempt was made to use a WHEN clause to reference
a column with a system trigger, but this type of trigger is
not supported because a system trigger does not have a base
table.

Action: Change the WHEN clause to an appropriate clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31062: Cannot delete an unsaved resource

1 Answers  


DRG-11204: user filter command is too long

1 Answers  


ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.

1 Answers  


ORA-24414: Only number sessions could be started.

1 Answers  


ORA-01573: shutting down instance, no further change allowed

1 Answers  






ORA-24025: invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type

1 Answers  


PCC-00056: FOR clause not allowed on SELECT statement at line number in file string.

1 Answers  


ORA-07580: spstp: $GETJPIW failure

1 Answers  


QSM-01103: there is a remote table, string, referenced in the query

1 Answers  


ORA-13121: layer type type mismatch with topo_geometry layer type

1 Answers  


TNS-12554: TNS:current operation is still in progress

1 Answers  


ORA-23360: only one materialized view for master table "string" can be created

1 Answers  


Categories