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: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Fri, 09 Aug 2002 14:20:11 GMT
Message-ID: <vcQ49.3930$fL3.1122377@news1.news.adelphia.net>


Or, you could go to www.toadsoft.com and get the free TOAD and use it to make comma delimited output of your table/s.

It is quite the useful tool.

"Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message news:X8Q49.3925$fL3.1121288_at_news1.news.adelphia.net...
> 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:20:11 CDT

Original text of this message

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