Re: PL/SQL

>
>I tried to print, from a PL/SQL procedure,
>in the screen the result from a query using
>the dbms_output.put_line. However, there
>is a limit of the bytes that I can store in the buffer.
>To overcome this, I put the result of the query in
>a temporary table and I printed the contents of
>this table from the SQL*PLUS.
>Is there a way to avoid the usage of a temporary table?
>
>Thanks in advance,
>greg
>
>

The default limit is 2000 bytes, I believe. However, it can go to 1000000 bytes. In sqlplus, enter the following:

sql> set serveroutput on size 1000000

If that is not enough, you will need to use other method (but a million characters aren't enough???)

Dan Hekimian-Williams Received on Sun Aug 30 1998 - 01:27:55 CDT