-
Retrieve CLOB Data Type from Oracle
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules