Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Triggers & Validations
William,
Your colleague is correct. Processing inside trigger is part of transaction
taking place only on the Oracle side.
What you can do is to stop execution of the trigger by issuing :
...
Raise_Application_Error(<nCustomErrorNumber>,<cErrorMessage>);
...
This will stop trigger and automatically rollback all elements of this
transaction.
On Powerbuiler side just check for returned error messages and you will be
able to display
<cErrorMessage> string in your application Messagebox.
HTH
Thomas
Received on Thu Jun 21 2001 - 22:17:45 CDT