Hi,
i'm using this code in a bash shell :
sqlplus user/pw@DB << EOF
@scriptRCA.sql $1 $2;
exit;
EOF
The sql script execute some delete, insert and update.
I need to write in a log file the output i could see in the console, for example
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ORA-06512: at "SYS.XMLTYPE", line 296
ORA-06512: at line 1
ORA-06512: at line 17
I googled for this and i've found a lot of suggestions, but no one work....
i'm quite desperate
Help me pleas