Re: Problem with having more than 1 statement in SqlPlus

No, My O/S is NT

On Tue, 14 Sep 1999 13:53:16 -0400, Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote:

>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 - 13:46:06 CDT