ORA-04084: cannot change NEW values for this trigger type
Question: I am running a trigger, and I get this
error:
ORA-04084: cannot change NEW values for this
trigger type
What causes the ORA-04084 error, and how do I prevent this error?
Answer:
Start by using the
oerr utility to look-up the error:
ORA-04084: cannot change NEW values for this
trigger type
Cause: New trigger variables can only be
changed in before row insert or update triggers.
Action:
Change the trigger type or remove the variable reference.
ORA-04084 is typically associated with an "after" row INSERT or
UPDATE trigger.
The ORA-04084 error is caused because the value is already in the
table; therefore, it's not new anymore.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
