PL/SQL

 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 Sat Aug 29 1998 - 07:53:17 CDT