Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ORA-00911: invalid character when executing INSERT statement with ; in TOAD
In TOAD, when I execute the following INSERT statements
with semi-colon in the end, I will get error
"ORA-00911: invalid character"
INSERT INTO T1 (A, B) VALUES ('Joe','1001'); INSERT INTO T1 (A, B) VALUES ('May','2001'); INSERT INTO T1 (A, B) VALUES ('Cat','3001');
If I execute in Oracle SQL*PLUS, it is fine with semi-colon.
But If I eliminate all semi colon, then I will get error "ORA-00933: SQL command not properly ended."
INSERT INTO T1 (A, B) VALUES ('Joe','1001') INSERT INTO T1 (A, B) VALUES ('May','2001') INSERT INTO T1 (A, B) VALUES ('Cat','3001')
In TOAD, it only has problem for INSERT statement with semi-colon. When I execute SELECT statement, it is fine.
Any ideas? Received on Fri Aug 12 2005 - 12:43:10 CDT