469,586 Members | 2,207 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,586 developers. It's quick & easy.

Convert Long to Varchar

Hi all,

I have a nice problem. Im trying to convert a Long to varchar2. It
works when the long field doesnt contain more than 2000 characters.
How do I solve this?

Im working with Oracle 7 by the way.

/Fred
Jul 19 '05 #1
1 19105
Fred wrote:
Hi all,

I have a nice problem. Im trying to convert a Long to varchar2. It
works when the long field doesnt contain more than 2000 characters.
How do I solve this?

Im working with Oracle 7 by the way.

/Fred


SQL or PL/SQL?
SQL: try "set long <an arbitrary large value>"
PL/SQL: a varchar variable holds 4k/32k max, so you
are stuck. 32k when you just want to use it, 4k when
you want to interface with it (e.g. store in a table)

--

Regards,
Frank van Bortel

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by Lauren Quantrell | last post: by
4 posts views Thread by v0lcan0 | last post: by
7 posts views Thread by James o'konnor | last post: by
2 posts views Thread by John Smith | last post: by
2 posts views Thread by kirke | last post: by
6 posts views Thread by scott ocamb | last post: by
1 post views Thread by Fred | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.