Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Mulitple Statements on the Same LIne
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 “@” symbol. The alternative is rewrite this files.
Thanks for any help you can supply. Received on Thu Jun 20 2002 - 10:21:40 CDT
![]() |
![]() |