Re: Triggers and commits

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Wed, 22 Sep 1999 14:43:50 +0100
Message-ID: <YlGuTIAW0N63EwlT@ahardy.demon.co.uk>

In article <7sajl7$669$1_at_nnrp1.deja.com>, lucas.m.anderson_at_ac.com writes
>I have a trigger that calls several stored procedures. Within the
>procedures are commits. When I performed the action that kicks off the
>trigger, Oracle tells me that it cannot perform a commit within a
>trigger.
>
>How can I get around this?

You could consider using pipes to send the 'requests' to another listening session and do the commits there. E.G Trigger fires, sends a request for the other session to run a procedure and commit it.

Andy
>The commits are necessary because we need
>to be able to restart the procedures at controlled points if an
>exception occurred. On the other hand, we need to be able to kick off
>the procedures in an automatic fashion.
>
>Thanks,
>Luke
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
Andy Hardy. PGP key available on request

Received on Wed Sep 22 1999 - 08:43:50 CDT