Re: How to "DUMP" a clob?
Date: Wed, 2 Apr 2008 05:44:22 -0700 (PDT)
On Apr 2, 4:23 am, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> DEFINE _SQLPLUS_RELEASE = "1001000500"
> DEFINE _O_VERSION = "Oracle Database 10g Enterprise Edition Release
> 10.2.0.3.0 - 64bit Production
> I have a clob. I save data in it, and then I want to get it back out. I
> don't always get back what I expect. I would like to examine the "real"
> data in the clob.
> HOW can I examine the contents of the CLOB to see what is really in it?
> DUMP won't do it, and all the other functions appear to do char set
> translations before they show you anything, so the values you see don't
> actually tell you what you stored at all.
You need to convert it to a BLOB and inspect that. See DBMS_LOB.CONVERTTOBLOB() in the docs.
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Wed Apr 02 2008 - 07:44:22 CDT