Date: Thu, 06 Mar 2008 20:13:00 +0100
> create or replace trigger trg_i_au_clients
> before insert on au_clients for each row
> select au_clients_seq.nextval into :new.id from dual;
> I have error "java.lang.IllegalArgumentException: No SQL selected for
> execution.Position: 0".
> Why can it be? Please help.
Add a slash (/):
create or replace trigger trg_i_au_clients before insert on au_clients for each row begin
select au_clients_seq.nextval into :new.id from dual;
-- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me upReceived on Thu Mar 06 2008 - 20:13:00 CET