Trigger Help

It is saying

ORA-04084: cannot change NEW values for this trigger type

any idea
Thanks for your help

Thanks

I should have realized that an after trigger will not work. Here is your homework should you choose to accept it. It is possible to create a collection on rows that are being updated/inserted with the before trigger, and then use an after triger to iterate through the collection updating the records appropriately.

You will need a before row level trigger and after statement level trigger. You will also need to look at how collections work. Perhaps even create a package that has a collection that can be populated and then read by the after statement level trigger. When the after statement level trigger fires the data has already been saved and you should be able to make changes, but you can no longer access the :NEW and :OLD meta rows because the transactions will be over. Thus you need something external to the trigger to store what happened hence the collection.

Here is a link with some information on collections:

PL/SQL User's Guide and Reference

You can also look at an instead of trigger.

Instead trigger can be used only on views

I am just guessing

Any code is helpful

Thanks

I must have been thinking of Sql Server. Take a look at collections though, they will probably do the trick.