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