SQR and Oracle Triggers

[Gary Murphy <gmurphy@AGCONSULT.COM>]

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