From: AMARENDRA B NETTEM <nettama@charlie.cns.iit.edu>
Subject: Re: SQL*Plus and MAXDATA
Date: 1997/08/08
Message-ID: <33EB61AC.6B3A@charlie.cns.iit.edu>#1/1
References: <5s5gfh$4kq$1@news.flashnet.it>
To: Andrea Pallotta <anpallotta@flashnet.it>
Organization: WHITTMAN-HART INC., CHICAGO
Reply-To: nettama@charlie.cns.iit.edu
Newsgroups: comp.databases.oracle.server



Andrea Pallotta wrote:
> 
> Hi there!!
> 
> Some people in my group is working with Perl and HTML language to build
> some windows
> 
> and access an Oracle 7.1.6 DB in that way.
> 
> They build up a very large select ( some tables with many columns ), but
> SQL*Plus don't work and say something about MAXDATA.
> 
> The question is simple: It's possible to bypass MAXDATA??
> 
> There is a way to buil up large select over the limit of MAXDATA?
> 
> Oracle documentation use too few words about this argument!!
> 
> Thanks for any help
> 
> -------------------------------
> Riccitelli Danilo
> Digital Italia
> Gruppo di sviluppo

Either you can increase the MAXDATA value or decrease the
ARRAY value

SET ARRAY 2(default is 15)

Hope this helps
-- 
  AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)
  Certified Oracle DBA
  WHITTMAN-HART Inc.
  CHICAGO.