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

[R B <ru...@ho...>]

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

... Now in SQL+ this is no problem, but through SQuirreL I'm consistently 
getting ORA-00900: Invalid SQL statement.  Obviously my first shot was sans 
the "." and "run", but no luck, any way I try it.

I'm afraid I'm a SQL Server fellow and Oracle's still a bit new -- Though I 
realize this is more lkely a JDBC issue than a SQuirreL issue per se, I 
figured this'd still be a pretty good group to ask.

I'm using SQuirreL 1.1final1, Oracle 9i, and the Thin JDBC drivers.

Thanks,

Ruffin Bailey

_________________________________________________________________
Get tips for maintaining your PC, notebook accessories and reviews in 
Technology 101. http://special.msn.com/tech/technology101.armx