Re: Commits in Database Triggers

From: Brian Peasland <peasland_at_usgs.gov>
Date: Fri, 23 Mar 2001 13:53:40 GMT
Message-ID: <3ABB5564.83FBF2F5@usgs.gov>

When your trigger completes, an implicit commit should be performed for you. You don't have to do anything!

HTH,
Brian

bhogak wrote:
>
> I know that we cannot use Commits/ Rollbacks in regular Database
> Triggers. I am planning to use a Trigger at Database Startup. (I am using
> Oracle 8i). I need to update my Job Control table inside this trigger.
>
> How do I save my change if I don't use Commit?
>
> Thx.
> bhogak

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Mar 23 2001 - 07:53:40 CST