Re: load file for triggers

Graham Savage <savageg_at_logica.com> escreveu nas notícias de mensagem:7s85eq$r3a_at_romeo.logica.co.uk...
> Hello there everyone,
>
> I'm hoping that someone can help me out with this one, as I can't seem to
> find the answer in the docs...
>
> I'm creating a text file for setting up a database. I've the various
CREATE
> TABLE statements, and CREATE VIEW statements, but I'm having trouble
adding
> CREATE TRIGGER statements...
>
> 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
> ...
> DECLARE
> ...
> BEGIN
> ...
> END;
>
> gives an error, (PLS-00103), and tells me that is encountered the symbol
> "CREATE" I know that the triggers are fine, as if I place each in a
> separate file, then I can create each an every one of them, so the code
> itself is fine.
>
> So I guess my question is how do I properly terminate a trigger, so that
the
> parser knows that the PL/SQL block is finished? I thought that 'END;'
would
> have done it, but apparently not.
>
> Cheers
>
> - Graham
>
> PS I'm using Oracle8 on NT4 SP3
>
>
>

Hi,

Try to put a '/' in a separate line after the final 'END;' of each trigger.

HTH. Nilo npaim_at_zaz.com.br Received on Tue Sep 21 1999 - 20:26:43 CDT