Re: SQL*Plus Parameters

> > Has anyone seen this before?
> >
> > I start SQL*Plus, and login by typing
> > sqlplus Quantum/Password_at_BPrd
> >
> > I type:
> >
> > select '&1' from dual;
> >
> > it responds
> > old 1: select '&1' from dual
> > new 1: select 'Files\_Tools\ora816\sqlplus\admin\glogin.sql' from
> > dual
> >
> > Where on earth did "Files\_Tools\ora816\sqlplus\admin\glogin.sql" come
> > from?!?!?!
> >
> > This does not happen if I copy SQL*Plus to the root folder and execute
> > it from there.
> >
> > Can anyone cast some light on this?
>
> I attempted to duplicate your post but I am on AIX 5.2 running Oracle
> 9.2.0.4 and SQLPlus queried me for the value of the label, which is
> probably what you expected.
>
> However, I would point out that &1, &2 are for positional parameters
> passed on a start line as in "start my_script 110 Tuesday". In a
> script that you expect to execute from the SQLPlus command line
> without passed parameters you should just use a name instead of a
> number for the label variables: &limit or something.
>
> You appear to be on Windows so perhaps the global login file is passed
> to sqlplus as its first parameter and the value is not cleared. I am
> willing to bet the parameter would work fine if the script was execute
> via a start with parameters.
>
> HTH -- Mark D Powell --

(Thinks -- Hmmmm, I could have a money making opportunity here...)

How much would you be willing to bet?

Unfortunately it does it for parameters passed from the command line too. The first command line parameter is ignored/oblitereated and replaced by "Files\_Tools\ora816\sqlplus\admin\glogin.sql". Subsequent parameters (&2, &3, etc.) seem fine.

Work arounds are pretty obvious, but it pains me admit defeat to this kind of trivial nonsense.

Thanx for your comments,

--Peter Received on Wed Jul 28 2004 - 06:10:05 CEST