Re: Mulitple Statements on the Same LIne

In article <7441da67.0206200721.1810a8d4_at_posting.google.com>, bracyrspam_at_yahoo.com says...
>
>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.
>

can you wrap:

BEGIN
>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;
end;
/

around those statements? then it'll work. (be nice if you added:

alter session set cursor_sharing=force;

to the script as well to "autobind" those things....

>
>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.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp