Re: SQR and Oracle Triggers

[Eric Dimick Eastman <erice@ONTKO.COM>]

Gary,

The triggers fire when the DML occurs.  Any changes the trigger may make would
become part of the roll back buffer of that connection.  If you have triggers in
the DB be sure to put "on-error" clauses on your begin-sql blocks.

Good luck,
Eric

Gary Murphy wrote:

> Does anyone know when an Oracle Trigger actually gets fired when a triggering
> condition is met while running an SQR program?  For example, my client has
> installed Oracle Triggers (against my recommendation) for an interface.  A
> PeopleSoft delivered SQR inserts rows into a table that is the firing 
>mechanism
> for this trigger.  However, does the trigger only fire after the SQR program
> performs a "commit" associated with that insert; meaning that the trigger only
> executes on a successful SQR run.  Or, does the trigger fire within the SQR
> program's execution when the insert is actually performed and, therefore, the
> Oracle trigger becomes part of the SQR program?  This means that if the SQR
> program abends the trigger would "rollback" any changes it made along with any
> changes the SQR made?  It also means that if the Oracle trigger abends a nasty
> return code is sent to the SQR program making it abend too.
>
> Thanks in advance!
> Gary