Originally Posted by vaibhavs17
Please help on below snippet of code.
below snippet of code is working on some environment...but onother it is now working saying invalid username/password
rm -f $SPOOL_FILE
sqlplus -s /nolog <<-! > /dev/null
whenever sqlerror exit 1
whenever oserror exit 1
Help with what??? You don't say what version/distro of Linux, what the rest of the script looks like, where it gets those variables, etc.
If it says "invalid user name/password", then I'll take a wild guess that the user name or password is wrong. Fix it.