Re: How to "DUMP" a clob?

From: Vladimir M. Zakharychev <>
Date: Wed, 2 Apr 2008 05:44:22 -0700 (PDT)
Message-ID: <>

On Apr 2, 4:23 am, (Malcolm Dew-Jones) wrote:
> Hello
> DEFINE _SQLPLUS_RELEASE = "1001000500"
> DEFINE _O_VERSION = "Oracle Database 10g Enterprise Edition Release
> - 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) Received on Wed Apr 02 2008 - 07:44:22 CDT

Original text of this message