Re: Trigger
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 7 Mar 2008 14:16:16 +0100
Message-ID: <47d14029$0$14355$e4fe514c_at_news.xs4all.nl>
Date: Fri, 7 Mar 2008 14:16:16 +0100
Message-ID: <47d14029$0$14355$e4fe514c_at_news.xs4all.nl>
<Bumsys_at_gmail.com> schreef in bericht
news:5c0cd8b2-7001-4214-825d-597ee4280aa9_at_59g2000hsb.googlegroups.com...
> 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.
From which (appearantly java)tool do you run this statement? I think Frank may be right....
Shakespeare Received on Fri Mar 07 2008 - 14:16:16 CET