Re: PL/SQL

Another method.

You can put a line in your pl/sql procedure the following line

dbms_output.enable(your_output_size)

HTH Madhu Cherukuri

gp wrote in message <904394968.7218.0.nnrp-01.c2de48da_at_news.demon.co.uk>...
> Hi,
>
>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
>
>
>
>
Received on Mon Aug 31 1998 - 19:40:58 CDT