2 issues with command line window

[Nicolas D.]

Hi,

2 Issues I did found out with Command Line window:

- If running a script with parameter by setting in editor something like:
@ script.sql param1 param2
Parameters are not translated and stand as &1 &2... Workaround is to run with sqlplus instead by using the "sqlplus" command.
- which lead to my second issue. One of that script was to be run as SYS.. but running sqlplus from a session connected as SYSDBA do not pass the "AS SYSDBA" to Sqlplus command

Version 13.0.6 64bits Windows 8.1 Oracle 19c client.

 

[Marco Kalter]

I created a script c:\temp\prompt.sql with the following contents:

prompt &1 &2

I ran this script from the Command Window with the following results:

scott@chicago> @c:\temp\prompt.sql abc def
abc def

This does not work for you?

We'll fix the "AS SYSDBA" issue.

 

[Nicolas D.]

I just retested and it work... must have gotten a temporary issue or something fancy as it did fail that time - and got my value inserted with &1 &2 rather than the value. so ok, no issue there, my bad.

Therefore Only the AS SYSDBA issue when invoking sqlplus remain.