Triggers in scripts

#1

I have a SQL script that creates tables, sequences, indices and even
inserts some data. Typically it is run by copy/paste into TOAD. A need
has arisen to create a few triggers. If I put the trigger code in this
script, all code following the trigger gets interpretted as being part
of the trigger. Do I need to create a script for every trigger or is
there a way to include them all in this one script? The client is
running Oracle 9i.

Thanks.

#2

Jørn Hansen wrote:

Quote:

No One wrote:

I have a SQL script that creates tables, sequences, indices and even
inserts some data. Typically it is run by copy/paste into TOAD. A
need has arisen to create a few triggers. If I put the trigger code
in this script, all code following the trigger gets interpretted as
being part of the trigger. Do I need to create a script for every
trigger or is there a way to include them all in this one script? The
client is running Oracle 9i.

Thanks.

Usually - you should end your code with a '/' on a single line.

Example:

CREATE TRIGGER ...
...
END;
/

I tried that, but it didn't seem to work. I will try again though.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Triggers in scripts

comp.database.oracle comp.database.oracle

Triggers in scripts - 12-28-2005 , 06:46 PM

Re: Triggers in scripts - 12-29-2005 , 07:09 AM