Hi, I try to execute a SQL statement containing 2 INSERT clauses.To separate the 2 INSERT, I put a ; but I got the error : ORA-00911: invalid character (DBD ERROR: OCIStmtExecute)
Here is my statement: INSERT INTO tblendbatch(lngidbatch_endbatch,lngidend_endbatch,lngidseqsize_endbatch,intminlength_endbatch) VALUES (1,1,1,500); INSERT INTO tblendbatch(lngidbatch_endbatch,lngidend_endbatch,lngidseqsize_endbatch,intminlength_endbatch) VALUES (1,2,2,250) I got the same error when the ; is replaced by a space. I know the ; is to be avoid for one statement (that work fine) but how to separate 2 clauses in the same statement ? Thanks -- ************************************************** Eddie IANNUCCELLI Tel: 05 61 28 54 44 - Fax: 05 61 28 53 08 INRA, Laboratoire de G�n�tique Cellulaire Chemin de Borde Rouge - Auzeville -BP27 31326 Castanet Tolosan **************************************************
