Re: Generated data file contains error messages !!!

Hi,

Not good but .. serve purpose ..
use "grep -v " for lines which you do not want to show ..

sqlplus / << eof | grep -v "^ORA-[0-9][0-9][0-9][0-9][0-9]" | grep -v "^ERROR at line" > jsoutput
select count(*) from no_table;
select count(*) from dual;
exit
eof
[ora9_at_js ora9]$
[ora9_at_js ora9]$ sh a.sh
[ora9_at_js ora9]$
[ora9_at_js ora9]$ cat jsoutput

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 1 01:34:06 1999

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> select count(*) from no_table

                     *

SQL>
  COUNT(*)

         1

SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production Received on Fri Sep 23 2005 - 08:35:21 CDT