SQL*Plus pass path to script file from command line

Question

What I'd like to do is parameterize the SPOOL path "C:\" so that in command line I can pass a path.

Sample script MyFile.sql:

SPOOL "C:\Temp\File.csv"  --How do I parameterize this?
SELECT Column FROM Table
SPOOL OFF

CommandLine: SQL> @C\MyFile.sql --Would like to pass in a path here.

DCookie · Accepted Answer · 2016-07-28 02:33:22Z

2

Or you could do:

SPOOL &1
SELECT...
SPOOL OFF

SQL> @C\MyFile.sql C:\Temp\File.csv

answered Jul 28, 2016 at 2:33

DCookie

43.7k11 gold badges88 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Arcan3 · Accepted Answer · 2016-07-27 22:48:05Z

1

The easiest way i can think of would be to call sqlplus from a .bat file that takes as input the parameter, writes out a primary SQL script which contains the spool + the parameter and then calls your actual script.

You would get an extra @secondary_script_name.sql at the beginning of output though.

answered Jul 27, 2016 at 22:48

Arcan3

891 silver badge5 bronze badges

Collectives™ on Stack Overflow

SQL*Plus pass path to script file from command line

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related