SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlplus and error output

abdujaparovMay 4 2009 — edited May 4 2009

Hi,
I have a problem, I open a sqlplus session on a bash script and I have to catch the error output.
I try to redirect the error output in this way:

sqlplus $DBCONN_STRING <<! 1>>$MSG_FILE 2>>$ERR_FILE

But in this way I have the ERR_FILE (that have to contain the errors) blank! The error is in the MSG_FILE (that contains other information, but I need only error.

How can I put the error messages in ERR_FILE?
Thanks, bye bye.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2009

Added on May 4 2009

2 comments

1,024 views