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.

> Any ideas?

Try executing as a batch?

Paul...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, as a courtesy to those who spend 
time analysing and attempting to help, please 
do not top post.