how do i insert a shell var into sqlplus ?

[lvikel2]

i need to insert a shell var into sqlplus, sqlplus needs to run an sql file but i want to make the direcroty of the sql file dynamic by var.

thanks.

[Scorby]

accept sqldir prompt 'Dir: '

@&sqldir/sqlscript

[ebrian]

You could do something like:

#!/usr/bin/ksh
v_dir=/tmp
sqlplus -s scott/tiger @${v_dir}/test.sql