bhanupraveen
09-29-2015, 11:02 PM
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
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