Re: Problem with having more than 1 statement in SqlPlus

I believe the problem is his SQL DELETE statement

try: delete * from event;

KM wrote:

> Have you tried taking out the semicolons (but leave the slashes between
> statements)?
>
> <svedloff_at_ix.netcom.com> wrote in message
> news:37de881f.7287899_at_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 Wed Sep 15 1999 - 06:57:28 CDT