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: Problem with having more than 1 statement in SqlPlus

Re: Problem with having more than 1 statement in SqlPlus

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Tue, 14 Sep 1999 13:53:16 -0400
Message-ID: <37DE8B8C.EDD3E05@Unforgettable.com>


svedloff_at_ix.netcom.com wrote:

> I am using Personal Oracle 8, and I am ahvign probelm with having
> more than 1 SQL statement in SqlPlus.
>
> I have a file, called mydata.sql, that looks like this:
>
> delete from Event;
> insert into Event (EventID, EventType) values(1, 'test');
> insert into Event (EventID, EventType) values(2, 'test');
>
> When i run it in SqlPlus, I get the following:
>
> SQL>
> 1 delete from Event;
> 2 insert into Event (EventID, EventType) values(1, 'test');
> 3* insert into Event (EventID, EventType) values(2, 'test');
> 4 /
> delete from Event;
> *
> ERROR at line 1:
> ORA-00911: invalid character
>
> SQL>
>
> The '/' on line 4 I had to enter myself. The asterisk showed up
> directly under the semicolon on the line above it.
>
> I also tried putting '/' after each line, and I got the same problem:
>
> delete from Event;
> /
> insert into Event (EventID, EventType) values(1, 'test');
> /
> insert into Event (EventID, EventType) values(2, 'test');
> /

Is UNIX your OS? If so, in vi enter the command "set list" to see if there are any hidden characters.














Received on Tue Sep 14 1999 - 12:53:16 CDT

Original text of this message

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