Devart Forums

Hi,

I have problem with my application when using direct mode. When i run a query that fetches a clob the application hangs when i open the query. If i set direct = false on the session and re-run the query it works fine and the clob is retrieved. Do you know of any any issues using Clobs with direct mode? I am testing with Delphi 2010 and odac 6.9.

thanks,

jp

Hello

We don't know about any issues with Clobs in the Direct mode. Unfortunately, the information you have provided is not enough to reproduce your issue. We need additional information.

Try to determine if the application hangs when your recordset contains some specific record or the application hangs when your recordset contains a lot of records with huge Clobs.

If your application hangs when your recordset contains some specific record then please send us the Clob field value of this record.

Hi ,

I do not think this relates to the content of the clob. I am updating the clob field with various values through indirect mode and trying to read it back via direct mode which fails to read the clob every time - the application just hangs when i open the query containing the clob.

Please can you advise if there is any thing i can try to resolve this?

thanks,

jp

Hi,

Please could you let me know if there is a solution to this?

thanks,

jp

Hello

I sent answer by E-mail.