Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007

    Exclamation Unanswered: Retrieving CLOB data through excel

    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!

  2. #2
    Join Date
    Jul 2007

    Unhappy A work around...

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts