trigger newb: Prevent certain records from being updated
I want to prevent a record from being updated if it has child records.
I would also like an error to be raised if possible. That terminology might not make sense, like I said, I'm new to triggers (this is my first one) ;)
In other words, rather than just have the update fail or be blocked by the trigger, I would like it if I could somehow catch an error thrown by the trigger to disaply on the client.
I'm using the .NET connector.
I've searched for examples of triggers that return an error but haven't found anything.
I just need a kickstart on this trigger creation and I think I will be able to figure out the details. If anyone could show me a quick sample of hwo to return or print an error from a trigger, that would be fantastic.
Thanks for reading,
Steve
Subject
Views
Written By
Posted
trigger newb: Prevent certain records from being updated
2489
October 27, 2006 10:34AM
1423
October 28, 2006 12:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.