multiple "create trigger" commands in one script file [message #21239] |
Fri, 19 July 2002 04:48 |
dbvhelp
Messages: 1 Registered: July 2002
|
Junior Member |
|
|
Hello,
I'd like to create ~35 trigger commands in one big SQL file, but Oracle can't correctly recognize any of the triggers. The triggers, entered alone, are correctly recognized and work.
It seems as if Oracle doesn't recognize the end of the first trigger command correctly and interprets the whole file as one big trigger - which of course results in failure.
How are CREATE TRIGGER commands properly closed? Here is an example of one of the triggers we use:
CREATE TRIGGER test_trigger
BEFORE INSERT ON test
FOR EACH ROW
BEGIN
SELECT test_seq.nextval INTO :new.id from dual;
END;
|
|
|
|
|