Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00911: invalid character when executing INSERT statement with ; in TOAD

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@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 Sat Aug 13 2005 - 22:18:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US