Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_output alternatives?

Re: dbms_output alternatives?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 16 Oct 2001 21:22:41 +0100
Message-ID: <3BCC9711.68EE@yahoo.com>


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..."
Received on Tue Oct 16 2001 - 15:22:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US