Re: How to "DUMP" a clob?

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Wed, 2 Apr 2008 05:44:22 -0700 (PDT)
Message-ID: <4d570dcc-09d6-47ec-a21d-e7695d0232b8@u36g2000prf.googlegroups.com>


On Apr 2, 4:23 am, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> Hello
>
> 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.

Hth,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Wed Apr 02 2008 - 07:44:22 CDT

Original text of this message