Re: How to "DUMP" a clob?
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