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

Re: Problem with having more than 1 statement in SqlPlus

From: Pam Lantzy <plantzy_at_uamail.albany.edu>
Date: Wed, 15 Sep 1999 07:57:28 -0400
Message-ID: <37DF89A8.3080688@uamail.albany.edu>


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

Original text of this message

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