by Frank van Bortel <frank.van.bortel@[EMAIL PROTECTED]
>
Mar 6, 2008 at 08:13 PM
Bumsys@[EMAIL PROTECTED]
wrote:
> 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;
> end;
>
> 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;
end;
/
--
Regards,
Frank van Bortel
Top-posting in UseNet newsgroups is one way to shut me up
