Re: Long Datatype: How to get everything out???

From: Michiel Ploeger <nospam.Michiel.Ploeger_at_Bluewater-Group.Com>
Date: Tue, 21 Sep 1999 15:56:55 +0200
Message-ID: <7s834f$ans$1@news1.xs4all.nl>

Did you set the long variable to 8192 for example ?

SQL>set long 8192<ENTER>

M. Ploeger

weicai_at_my-deja.com wrote in message <7s7ukq$8iq$1_at_nnrp1.deja.com>...
>Hi, All
>
>I use Oracle 7. I have saved large amount of email content into
>database. The field I used is long datatype. I can successfully insert,
>however when I use SELECT statement to retrive the data, it truncate
>the content and only part of the contents returned. It also give me the
>following error message
Received on Tue Sep 21 1999 - 08:56:55 CDT