How to handle CLOB Data in VBA for Excel?

How to handle CLOB Data in VBA for Excel?

• Jerome Bonnet

  per our support engineer:

  Would you please ask our ISV to check whether the document (below) can resolve the issue

  How To Use ADO GetChunk/AppendChunk with Oracle for BLOB Data

  http://support.microsoft.com/ id=185958

  And please let our ISV know that the database he used is not our product. We can offer more samples of the SQL server, he can try to use them on other database OS.

  -brenda (ISV Buddy Team)

  
  
  

• Tore Bleken

  Hello,
  
  I tried what was on that document. When the recordset is open and runs the SQL statement, it gives me an error:
  
  

  Run-time error '-214767259 (80004005)
  
  Unspecified error
  
  
  I tried to select only fields that weren't the CLOB one. It works. However, when I try to do a SELECT in
  the CLOB field, it gives me this error. What can I do 
  
  Thanks.
  

  
  
  

• Lasha

  Here's the latest from our support engineer:

  Would you please ask our ISV to try the code below

  The VB6 Code:
  
  Set objCMD = New ADODB.Command
  With objCMD
  Set .ActiveConnection = idapiDBCon.DBConnection
  .CommandText = "Stored_Procedure_Name"
  .CommandType = adCmdStoredProc
  // Other Parameters
  .Parameters.Append .CreateParameter("@Stream", adLongVarChar, adParamInput, 2147483647, "")
  .Execute , , adExecuteNoRecords
  End With
  
  ------------------------------------------------------
  The PL/SQL Code in the Procedure:
  procedure Stored_Procedure_Name
  (
  // Other Parameters
  pilStream in CLOB
  ) as
  
  begin
  
  insert into tblLDAP
  (
  // Other Columns
  Stream
  )
  values
  (
  // Other Parameters
  pilStream
  );
  end Stored_Procedure_Name;
  ---------------------------------------------------------

  -brenda (ISV Buddy Team)

  
  
  
• How to handle CLOB Data in VBA for Excel?