[EMAIL PROTECTED] (Eddie Iannuccelli) writes: > 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)
You have to do two separate statements. A semicolon works in PL*SQL but not through DBI. If you are concerned about one succeeding and the other failing, use a transaction and a commit/rollback at the end. --Bill. -- William R Ward [EMAIL PROTECTED] http://www.wards.net/~bill/ ----------------------------------------------------------------------------- If you're not part of the solution, you're part of the precipitate.
