Re: piece-wise fetching.....
From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 26 Nov 2001 07:38:16 -0800
Message-ID: <9ttnl801eqb_at_drn.newsguy.com>
Date: 26 Nov 2001 07:38:16 -0800
Message-ID: <9ttnl801eqb_at_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_at_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 CorpReceived on Mon Nov 26 2001 - 16:38:16 CET