On Apr 2, 4:23 am, yf...@[EMAIL PROTECTED]
(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
|
