Re: enabling triggers

Have you tried to enter the forward slash (/) ? The semi-colon, in PL/SQL, is the end of line character.

Dave Grzebien
Expert Technical Consultants, Inc

Greg DeMent wrote:

> 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 - 21:38:39 CST