Re: dbms_output alternatives?

From: Marc Blum <marc_at_marcblum.de>
Date: Mon, 15 Oct 2001 19:18:49 GMT
Message-ID: <3bcb35fa.3053941@news.online.de>

On Mon, 15 Oct 2001 17:36:04 GMT, "Jeff Wilson" <jwilson2000_at_home.com> 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
>
>

(1) You can use UTL_FILE to write directly into a file. That way, you don't need SQL+.

(2) Write the desired output into a table. Then query the contents of the table via SQL+

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Mon Oct 15 2001 - 14:18:49 CDT