I try to execute follow bash script:
#!/bin/bash
output=`sqlplus -s "sqlplus test/test@rac1.localdomain:1521/GDBN @test.sql 'var1' 'var2' " <<EOF
set heading off feedback off verify off
exit
EOF
`
echo $output
if [[ $output =~ ERROR ]]; then
echo "ERROR"
else
echo "OK"
fi
it do not work for me.
I don't know how to format this 2 string parameters var1 and var2 inside on bash script.
How can I pass this parameters in this case?
Have someone any experience how to do this?
Regards