Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with Long.
Hi,
How do you know it's getting truncated when storing?
If you want to see the column in sqlplus, do a
set long 100000
and then try and view the column.
If 100000 is not big enough, choose something bigger.
Hope that helps.
Cindy
Abhimanyu Parasher wrote:
> Hi!
> Thanks for reading this posting. I'm a newbie in this area & facing a problem with datatype Long. When I try to insert data in this column the data gets truncated. I want to use this datatype to store text from e-mail messages.
>
> Can any body help to sort out this problem or guide me to use some other alternative to store this kind of data ?
>
> I need it very urgently.
>
> Please help.
>
> Thanks & Regards
>
> Abhimanyu Parasher
>
> --
>
>
>
Received on Fri Jul 16 1999 - 03:55:17 CDT
![]() |
![]() |