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

Problem with having more than 1 statement in SqlPlus

From: <svedloff_at_ix.netcom.com>
Date: Tue, 14 Sep 1999 17:46:22 GMT
Message-ID: <37de881f.7287899@nntp.ix.netcom.com>


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>
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');
/
Received on Tue Sep 14 1999 - 12:46:22 CDT

Original text of this message

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