Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Converting LONG type to VARCHAR2...
The following doc tells how to find the length of a LONG, but does so by retrieving it in measurable chunks. Those chunks might be just what you need. I have not tried this, but hope it is useful to you.
http://www.oramag.com/code/tip12206.html
+----------------------------------------------------- | Dan Townsend, Supervising Database Architect| EBMUD Enterprise Object Designer
+-----------------------------------------------------TinHa wrote: