Oracle Database Discussions

Hi,

I did a search in this forum and I couldn't find the answer.

I am unloading (spooling) a table using sqlplus. Since I don't want to display these records on screen I am using set termout off.
But I want to see error messages on the screen. I used whenever sql error exit sql.sqlcode. It is displaying the error messages in the spool file. But I would like to have these on screen so that I can capture all my errors in to a log file.

Thanks in advance,
Naren