Re: Trigger

Bumsys_at_gmail.com 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