Re: Problem executing file with more than one statement in SqlPlus

<svedloff_at_ix.netcom.com> wrote in message news:37de9651.10921083_at_nntp.ix.netcom.com...
> I am using Personal Oracle 8 and I am having problem executing a file
> with more than one SQL statement in SqlPlus. My file looks like this:
>
> delete from Event;
> insert into Event (EventID, EventType) values(1, 'test');
> insert into Event (EventID, EventType) values(2, 'test');
>
> When i execute it I get this:
>
> 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

[snip]

Hi, svedloff,

Do not use GET to get the contents of a file and then run it, unless the file contains only 1 statement. Just use START or @ to run the file. Received on Thu Sep 16 1999 - 11:13:57 CDT