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 -> Mulitple Statements on the Same LIne

Mulitple Statements on the Same LIne

From: bracyr <bracyrspam_at_yahoo.com>
Date: 20 Jun 2002 08:21:40 -0700
Message-ID: <7441da67.0206200721.1810a8d4@posting.google.com>


I am a newbie using Oracle. I am using Oracle8i 8.1.6.1.0 on a mainframe MVS platform, using SQLPLUS. I need to submit multiple commands on the same line separated by a semicolon like the code below. The SQLTERMINATOR is set the semicolon.  

INSERT INTO BRACYR.GARDEN2(USERID,USERPW,LAB_CODE,EMAIL)

VALUES('ID1','PW1','LAB1','EMAIL1'); INSERT INTO              
BRACYR.GARDEN2(USERID,USERPW,LAB_CODE,EMAIL)               
VALUES('ID2','PW2','LAB2','EMAIL2'); COMMIT;                  

I get this error:
ERROR at line 2:
ORA-00911: invalid character

If I break the commands on to the next line after the semicolon it works fine. I have much bigger files that I will include with the &#8220;@&#8221; symbol. The alternative is rewrite this files.

Thanks for any help you can supply. Received on Thu Jun 20 2002 - 10:21:40 CDT

Original text of this message

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