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: load file for triggers

Re: load file for triggers

From: Alan Shein <alanshein_at_erols.com>
Date: Tue, 21 Sep 1999 13:48:18 -0400
Message-ID: <7s8ga2$nmg$1@winter.news.rcn.net>


>>

The problem appears to be that when parsing the load file, it doesn't notice when one trigger stops and the next starts...

e.g.

CREATE TRIGGER myFirstTrigger

    ...
    DECLARE
    ...
    BEGIN
    ...
    END; CREATE TRIGGER mySecondTrigger

    <<

Have you tried making your END statements like this...

END myFirstTrigger;

instead of just "End;"? Received on Tue Sep 21 1999 - 12:48:18 CDT

Original text of this message

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