Re: HELP: Output from within Stored Procedure???
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