Hi,

I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.

For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?

--------------------------------------------------------
var1="ABC"
var2="123"
return_code=`sqlplus -s sars2d/password@kfdmlc <<end
set pagesize 0 feedback off ver off heading off echo off serverout on
variable rc number
exec kf_pkg_load.df_validate_file('SAS','20050612' ,null,null,null,null,null,null,null,null,:RC)
print rc
exit;
end`
--------------------------------------------------------

Thanks in advance for your help

John

Check this out.

Passing variables to sql from batch shell in linux
How to pass a oracle variable back to the shell script


If none of those suit your purpose, then use the search feature with the keyword sqlplus.

Vino