enabling triggers

From: Greg DeMent <dementg_at_usa.net>
Date: Wed, 29 Nov 2000 16:37:50 -0800
Message-ID: <3A25A15E.6CBB5BA4@usa.net>

In SQL*Plus, 8i

When I try to create a trigger, I get to the final semicolon and oracle doesn't respond to it. e.g.

CREATE TRIGGER TR_LOG
    AFTER INSERT ON MEMBER

        FOR EACH ROW
            BEGIN
                INSERT INTO ... ;
            END;

;
;

(I can type semicolons all day, and it never accepts the trigger statement)
Eventually I have to type <CTRL>-C to break back to the SQL prompt. I have read that I'm supposed to run CATPROC.SQL while logged in as SYS to enable triggers. When I do that, I get a "quoted string not properly terminated" error from the script. I've also tried running DBMSSTDX.SQL, as the documentation suggests, and it also throws an error regarding an undeclared variable.

How do I get this thing to accept triggers? As you can probably tell, I'm new at this. Thanks. Received on Wed Nov 29 2000 - 18:37:50 CST