Re: [Squirrel-sql-users] Creating triggers in Oracle in SQuirreL

[Maury H. <ml1...@sh...>]

R B:

> I'm trying to run the following SQL code:
> create or replace trigger trigEntityOw01aId
>     before insert on EntityOw01aId
>     for each row
>     begin
>         select seqEntityOw01aId.nextval into :new.entityOw01aId_Id from 
> dual;
>     End;
> .
> run

The problem you're running into is that SQuirreL is terminating the statement 
at the first ';'.  From the menu, select 'Session->Session Properties'.  In 
the 'SQL' tab, change the value of 'Statement Separator' from ';' to '/'.

Then try this:

create or replace trigger trigEntityOw01aId
     before insert on EntityOw01aId
     for each row
     begin
         select seqEntityOw01aId.nextval into :new.entityOw01aId_Id from dual;
     End;
/


Maury...