Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPLUS serveroutput buffer overflow

Re: SQLPLUS serveroutput buffer overflow

From: Edzard <edzard_at_volcanomail.com>
Date: 10 Aug 2002 05:36:48 -0700
Message-ID: <5d75e934.0208100436.31e36ad@posting.google.com>


> Why don't you create a master script and pass a value to delimit where you
> stop. That way, you would not fill the buffer though there will some extra
> work though minimal.
>
> call repeatedly
> for i ..from (&&2) to some value (&&3) loop
> bla bla...

Or use a temporary table:
CREATE TABLE results (outputline VARCHAR2 (1000)) /
BEGIN ..
 LOOP ..
    INSERT INTO results (outputline) VALUES ( .. /
SELECT * FROM results
/ Received on Sat Aug 10 2002 - 07:36:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US