Re: dbms_output alternatives?

Jeff Wilson wrote:
>
> I am using PL/SQL to gather information from a database and write a report
> using dbms_output. Unfortunately, certain rows in the report exceed 255
> characters, which is the limit of dbms_output.
>
> Is there a way around this problem? Is there an alternative to dbms_output?
>
> Thanks.
>
> Jeff Wilson

utl_file to write to files

or write your own version - all dbms_output does is store stuff in an array and then sqlplus drags it out. You could store your rows in a pl/sql table and then use SQL to query it out at the end

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."