Problem executing file with more than one statement in SqlPlus

From: <svedloff_at_ix.netcom.com>
Date: Tue, 14 Sep 1999 18:44:54 GMT
Message-ID: <37de9651.10921083@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

SQL> The '/' on line 4 I ahd to enter by myself. Also, the astetisk above the ERROR statement showed up directly underneath the semicolon.

I also tried this file:

delete from Event;
/

insert into Event (EventID, EventType) values(1, 'test');
/

insert into Event (EventID, EventType) values(2, 'test');
/

And I got the same probelm. Received on Tue Sep 14 1999 - 13:44:54 CDT