Re: SQR and Oracle Triggers

[Bill Scollard <bill_scollard@TRANSCANADA.COM>]

My knowledge of Oracle originates from V7 a few years ago, but I seem to 
remember
that Oracle triggers can be set to "fire" at or on about 15 different stages 
during
file modification steps to base tables. I am sure that there is a before-insert
possibility. You can tailor the Oracle triggers to perform their work at the 
time
that is best suited for your application. Regarding your rollback issue, I 
cannot
comment.

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

--
Bill Scollard
Systems Integrator
Gas Industry Systems FST
Rm 2414 TC-East
ph: (403)267-6379
fax (403)267-8773