Hello,

Need to get from Oracle table which contains CLOB datatype value. Able to query data if i remove CLOB field from Select, Below is my code:

con.Open con.ConnectionString
Set recset = New ADODB.Recordset
Sql = "SELECT CONFIG FROM MDI_APP_CONFIG WHERE CONFIG_TYPE LIKE '%CPC%'"
recset.Open Sql, con
Debug.Print recset.Fields(0).Value

When cursor tries to retrieve data, "Application Defined or Object Defined error '1004'"


Thanks,
Bhanu