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

jrefactors_at_hotmail.com wrote:
: 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?

It appears toad is submitting your code as a single statement. So either provide a single statement, or use some other options or entry point within toad that allows you to submit multiple statements.

--

This space not for rent.