By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,276 Members | 2,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,276 IT Pros & Developers. It's quick & easy.

SQL*Plus Parameters

P: n/a
Has anyone seen this before?

I start SQL*Plus, and login by typing
sqlplus Quantum/Password@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?
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
pe****@mailinator.com (Peter) wrote in message news:<c5**************************@posting.google. com>...
Has anyone seen this before?

I start SQL*Plus, and login by typing
sqlplus Quantum/Password@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 --
Jul 19 '05 #2

P: n/a
> > Has anyone seen this before?

I start SQL*Plus, and login by typing
sqlplus Quantum/Password@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
Jul 19 '05 #3

P: n/a
pe****@mailinator.com (Peter) wrote in message news:<c5*************************@posting.google.c om>...
Has anyone seen this before?

I start SQL*Plus, and login by typing
sqlplus Quantum/Password@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


Peter, you did not list your Oracle version. If you are on an older
version perhaps an upgrade will include a fix for this problem.

Have you searched metalink for the bug and possible patch?

HTH -- Mark D Powell --
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.