Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Tools > Re: Trigger
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 4 Topic 2719 of 2786
Post > Topic >>

Re: Trigger

by "Shakespeare" <whatsin@[EMAIL PROTECTED] > Mar 7, 2008 at 02:16 PM

<Bumsys@[EMAIL PROTECTED]
> schreef in bericht 
news:5c0cd8b2-7001-4214-825d-597ee4280aa9@[EMAIL PROTECTED]
> 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
 




 4 Posts in Topic:
Trigger
Bumsys@[EMAIL PROTECTED]   2008-03-06 03:31:30 
Re: Trigger
Frank van Bortel <fran  2008-03-06 20:13:00 
Re: Trigger
DA Morgan <damorgan@[E  2008-03-06 11:14:48 
Re: Trigger
"Shakespeare" &  2008-03-07 14:16:16 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Aug 21 20:43:32 CDT 2008.