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

From: James Kelly <jamesalankelly_at_verizon.net>
Date: Sun, 14 Aug 2005 03:18:03 GMT
Message-ID: <LJyLe.520$286.32_at_trndny09>


<jrefactors_at_hotmail.com> wrote in message news:1123868590.202441.109280_at_g49g2000cwa.googlegroups.com...
> 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?
>

I have found that in 7, you have to highlight all the statements you want to execute and then "Run as Script" rather than just execute.

James Received on Sun Aug 14 2005 - 05:18:03 CEST

Original text of this message