SQL Exception: State : 42000 Message: ORA-00911: invalid character Error :
843854Mar 10 2005 — edited Mar 10 2005Hello,
I am new to java. I am trying to insert a record ino the oracle database. But it gives me an sql exception.
SQL Exception: State : 42000 Message: ORA-00911: invalid character Error :
My sql query is:
INSERT INTO SERVER_CONFIG SELECT Bank_seq.NEXTVAL,'Bindu',1,2,3,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 from dual;
It works fine when I run this in SQL * Plus.
Plz help!