Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPLUS serveroutput buffer overflow
> 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
![]() |
![]() |