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.

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

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

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

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