Oracle: any replacements for DBMS_OUTPUT package?

Question

especially one that doesn't have the 256 max chars/line and 1000000 max chars/buffer limitation.

Answer 1

Maybe one of these options will suit your needs (depending whether you write something on server side or client side):

• UTL_FILE
• TEXT_IO
• AskTom post

(update by Mark Harrison) I went with the my-dbms-output package in the AskTom post. One really nice feature is that you can access the results via a view, so that it's easy to show the output in a client program. I renamed it to a shorter name.

Answer 2

What version of Oracle? Both of those limitations have been relaxed in recent versions. 10.2 supports lines longer than 255 characters (the new limit is 32k) and eliminates the maximum buffer size limitation. Oracle 9.2 had the 255 characters per line/ 1 MB total limit, but Oracle has desupported that version.