Re: SQLPLUS serveroutput buffer overflow

Too bad text_io is only available in Developer.

You could use utl_file, but that requires DBA intervention and access to the server that Oracle is on.

You could write a small program in a real programming language like Delphi, C++, JAVA, etc.

Using just SQLPlus I would set line size way big, set the lines per page way high and construct the select to output of the query in comma delimited form and then spool my output to a file and then use my favorite editor to massage the results.

Definitely not kewl, but that is Oracle for you.

"Peter Laursen" <ptl_at_edbgruppen.dk> wrote in message news:3d53b61a$0$13711$edfadb0f_at_dspool01.news.tele.dk...
> SYSTEM 8.05 and up, WinNT 4 and W2k.
>
> I made a sqlplus script that selects som data and spools them to a
> commaseparated file. The file exceeds the maximum size of the serveroutput
> var of 1000000 so the script terminates with ORU-10027 buffer overflow
limit
> of 1000000
> How can sove this? Can I empty the buffer during the run?
> If I set serveroutput off nothing is spooled out and I cannnot use PROMPT
in
> the pl/sql block
>
> the script takes a few parameters and then goes like:
>
> set serveroutput on size 1000000
> spool &1
> begin
> for i in (select blah) loop
> dbms_output.put_line(i.master, i.blah)
> for j in (select blah)
> dbms_output.put_line(j.detail lines);
> end loop;
> end loop;
> end;
> /
>
>
> TIA
> Peter Laursen
>
>
>
>
Received on Fri Aug 09 2002 - 09:16:23 CDT