Re: COMMIT in a trigger?

From: <mgogala_at_yahoo.com>
Date: Mon, 08 Feb 1999 06:18:36 GMT
Message-ID: <79lvjn$a19$1@nnrp1.dejanews.com>

In article <79kh6c$aai$1_at_news07.btx.dtag.de>, mattias.meyer_at_t-online.de (mme) wrote:
> Does anybody know how I can do a COMMIT in a trigger or procedures
> called by a trigger???
>
>

Why in the world would you like to do that? Triggers are invoked immediately before commit and are supposed to be a control mechanism that implements complex business logic and aborts invalid transactions. It is explictly said in the holly book (Applications Developers Guide) that you cannot do commit or rollback in trigers (Gospel by Larry).

Mladen Gogala

I'll speak the key,
The whole key
And nothin but the key
So help me Codd.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 08 1999 - 00:18:36 CST