I need to retrieve a table from Oracle using VBA (i can do this
easily), but in this situation one of the entries in the table is a
<CLOB.

i tried:
DBMS_LOB.substr(My_COL,2000,1)

and this seemed to help (or at least got me a step closer i thought)
to my desired solution
but still I cannot read the data into excel (i want to display it as a
string or character in a cell).

error received in VBA:
Run-time error '1004':
Application-defined or object-defined error

any help would be great.