output from PL/SQL

Hi,

I have PL/SQL routine I will be running from sqlplus. It generates output via DBMS_OUTPUT.PUT_LINE which I will eventually redirect to a unix file. That's all good and fine, my problem is that I don't want that

PL/SQL procedure successfully completed.

to end up in that file too.

Sofar I've come up with 3 ways to write a unix file

1. use spool in sqlplus (puts the PL/SQL procedure successfully completed. in the file and then some)
2. redirect the output from sqlplus -s (puts the PL/SQL procedure successfully completed. in the file)
3. use UTL_FILE (should work, but is nor practical, since files will be created, and then would be owned by user oracle)

So is there any other way of writing to files? Or does anybody know, how to get rid of that "PL/SQL procedure successfully completed."? I guess I could grep it out, hm I guess I'll do that, but I'd still be interested in how to suppress the printing of that message

Thanks

  Christian Received on Fri Apr 23 1999 - 14:23:10 CDT