Re: SQLPLUS command line question

From: george lewycky <gelewyc_at_nyct.com>
Date: 23 Feb 2004 07:28:06 -0800
Message-ID: <68aecc05.0402230728.138ce5aa_at_posting.google.com>


Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0402191731.6b2f928b_at_posting.google.com>...
> tommynospam_at_yahoo.com (tommy) wrote in message news:<4f0df91b.0402190957.4f8dd028@posting.google.com>...
> > I'm running sqlplus from a DOS command line and inducing an error by
> > purposly giving it the wrong script (hence, it cannot find the script
> > file.) What it is doing is exiting to the SQL> prompt as show below.
> > What I NEED it to do is exit to the DOS prompt.
> >
> > c:\>sqlplus someuser/mypass_at_mydb NonExistantCommandFile.sql
> > SQL>
> >
> > Does someone know how this can be done or have a commandline switch
> > reference that might have the answer?
>
> Look in the sqlplus manual for logon.sql (or perhaps login) scripts.
> You can set parameters in this file that will take affect when the
> session is started. You could set the sqlwhenever clause to exit on
> failure. At least this is what I would try. I am not on a computer
> with Oracle on it so I cannot test my suggestion but it should be
> pretty easy to test.
>
> HTH -- Mark D Powell --

You should place the SQL in your "BIN" directory and all you should need is

c:\_at_NonExistantCommandFile

also try saving something from the dos prompt and see where it gets saved and then place the sql code in that directory if its not the BIN directory

george Received on Mon Feb 23 2004 - 16:28:06 CET

Original text of this message