Problem with Triggers

From: Paul Wiles <john_at_adzi.com>
Date: Mon, 19 Apr 1999 14:26:39 +0100
Message-ID: <371b2ca9@newsread3.dircon.co.uk>

I'm running Oracle 8 server on Linux (Redhat 5.2)

I've got a TRIGGER on TABLE_A AFTER UPDATE OR INSERT

I also have a stored procedure (PROC_A) which performs an INSERT or UPDATE to TABLE_A.

When I call PROC_A, from MySQL, the session just hangs. There is only one trigger on this table so how could this be caused by infinite recursion in the trigger? Do Oracle triggers end up calling themselves under certain conditions? What else could cause this problem?

Any help much appreciated.

Paul Received on Mon Apr 19 1999 - 08:26:39 CDT