Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Triggers seem to be compiled only randomly

Re: Triggers seem to be compiled only randomly

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 02 Aug 2005 23:55:36 +0200
Message-ID: <3sqve155qsrnlob8nf5snrd6dnj8gkeb55@4ax.com>


On Tue, 02 Aug 2005 17:44:34 +0200, Andreas Mosmann <keineemails_at_gmx.de> wrote:

>Is there any explaination (I can reproduce this many times, there are
>some similar scripts with same differences)

Is there any business need for having 2 triggers on the same event? You should merge the two triggers into one. Other than that you should always provide *exact* error messages, or promise German lager to everyone who resolves your riddles, without the exact error message.

--
Sybrand Bakker, Senior Oracle DBA
Received on Tue Aug 02 2005 - 16:55:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US