Hello Everyone,

I am attempting to retrieve CLOB data from an Oracle database via a subroutine in excel.

I am using the Microsoft ODBC for Oracle driver to make the connection to the database.

When I attempt to return the CLOB (which is all text) I receive the following error:

"Run-time error '-2147467259(800004005)':
Automation error
Unspecified error"

How can I go about returning CLOB data from Oracle via my excel subroutine? I have a few different CLOB data fields to return to excel.

Thanks in advance!

For anyone interested it looks like the apparent fix in this case will be to modify the CLOB field on the Oracle side. This particular field is simply a text field that is allowing >255 characters causing the CLOB. The solution is to limit the field <255 characters to return it to excel. I will be able to do so being that the field does not have a justification to be >255 characters. In the event that I need to return data that is CLOB data, this issue remains unresolved. Simply circumvented.