w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
SQL*Plus command line parameters overwritten in Windows

I tried to reproduce with the native version of SQL*Plus coming with my Oracle 11gR2, and I cannot reproduce:

dummy.sql script:

prompt &1
prompt &2
prompt &3
prompt &4

select 1 a from dual;

exit

Output:

E:CFMDevSQL>sqlplus -s guest/guest@DEV @dummy.sql 1 2 3 4
1
2
3
4

         A
----------
         1


E:CFMDevSQL>

My first tries would be:

  • is your sqlplus executable native (or is it a kind of hand-made batch) ?
  • what is your OS ?

UPDATE: after your comments, I guess that glogin.sql must be called in some way as a command parameter, but without quotes around. My test works but the client is installed in C:oracle (no blanks), which may be why it works for me...

What I would do is re-install your client in a directory without blanks (why not C:oracle) because I think this could solve your issue.





© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.