This content has been marked as final. Show 3 replies
I have an sql file with multiple accept statements.Create text file and put one value per line in proper order. For example, you have the following script script.sql :
I would like to run this script from the DOS commandline, and supply the script with values for the accept statements.
How can I do this? (I do not want to alter the sql-file for this)
Text file values.txt can be the following:
accept V1 char prompt 'Enter value for V1:' accept V2 char prompt 'Enter value for V2:' prompt Your input : &V1 &V2 exit
Then use the following syntax:
sqlplus.exe /nolog @script.sql < values.txt
Thanks a lot. It works!
Is this documented somewhere? I couldn't find it.
This is standard OS behaviour, using file to redirect user input.