This content has been marked as final. Show 5 replies
Does the user who is running the shell script have the correct permissions on the directory to create the spool file?
I am not sure. Thanks for the hint though, I will follow up on that.
where does it not run from ? where do you get the error ?
This is fixed, thanks for the response. My script had some invalid white space characters which were not visible in Unix, this was causing some errors.
Message was edited by:
I Had the same issue
After adding <<EOF its worked
$ORACLE_HOME/bin/sqlplus /nolog @/myscript.sql <<EOF