ORA-00911: invalid character when executing INSERT statement with ; in TOAD

From: <jrefactors_at_hotmail.com>
Date: 12 Aug 2005 10:43:10 -0700
Message-ID: <1123868590.202441.109280_at_g49g2000cwa.googlegroups.com>

[Quoted] [Quoted] In TOAD, when I execute the following INSERT statements [Quoted] 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.

[Quoted] 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')

[Quoted] 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 - 19:43:10 CEST