Re: piece-wise fetching.....

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 26 Nov 2001 07:38:16 -0800
Message-ID: <9ttnl801eqb@drn.newsguy.com>

In article <4YjM7.91564$636.13071492_at_news02.optonline.net>, "jane" says...
>
>ERROR: piece-wise fetching
>Is there a way whatsoever to fix this infamous error in SQL*Plus ?
>
>Searched:
>Oracle.com
>asktom.oracle.com
>comp.database.oracle.* archives
>
>Found:
>whole lot of asking...
>no answers.....
>
>thanks
>jane
>
>

sigh, no versions......

what version of sqlplus, what is the setting of "set long" in your login.sql/glogin.sql -- or do you let it default.

There was an issue in some early 8.0 releases with regards to this on NT. Try setting

SQL> set long <big number, say 50000>

and retry.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Mon Nov 26 2001 - 09:38:16 CST