Trigger Question/Transaction

Hello,

I just want to be sure, because it's quite important to me:

I'm using some PL/SQL Code inside a Trigger. Two Statements (INSERT AND UPDATE) MUST execute at a transaction basis. Unfortunately, commits and rollbacks aren't allowed.

What exactly happens if after the first INSERT Statement the machine or ORacle goes down? If these Statements don't execute within a Transaciton, how do I accomplish that?

Sebastian Received on Sun Jul 29 2001 - 09:53:19 CDT