Re: HELP: Output from within Stored Procedure???

From: Sameer Utrankar <utrankas_at_coned.com>
Date: 1996/05/08
Message-ID: <4mqkvq$j2d_at_ins3.coned.com>#1/1


Very soon, you will hit the buffer overflow limit of 1M with dbms_output and then the answer would be dbms_pipe.

>>The problem is, I can't find the any statements in SQLPLUS that will
>>allow me to output to to STDOUT. I can use SQL queries invoked via
>>shell scripts that do the select, but in our application many queries
>>are needed and it is quite slow that way.
>>
>>Any suggestions?
 

>Further poking around has allowed me to answer my question. For those
>interested in the answer, the package DBMS_OUTPUT contains the
>procedures needed to accomplish the task.
 

>I don't know where that package is documented, but I found an example in
>the code from the book _Oracle PL/SQL Programming_ that is downloadable
>from http://www.osborne.com/oracle/ora12.htm.
 

>Ken



Utrankas_at_coned.com (Sameer Utrankar) Received on Wed May 08 1996 - 00:00:00 CEST

Original text of this message