Re: Generated data file contains error messages !!!

Laura wrote:
>Hi:
>I have a process that generates a datafile whith a query executed from
>sqlplus:
>
> sqlplus .... << eof > my_data_file
> set ...
> set ..
> select ...
> eof
>
>The problem is that when an oracle error happens, the error message is
>included inside de data file.
>How could I do for obtain de error message in a separated file?

Is there no way to avoid getting the error message in the first place?

-- 
Message posted via http://www.dbmonster.com