Clob problem with Direct Mode

jp · Post by jp » Wed 14 Apr 2010 14:39

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

bork · Post by **bork** » Fri 16 Apr 2010 06:38

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.

jp · Post by jp » Wed 21 Apr 2010 11:52

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

jp · Post by jp » Mon 26 Apr 2010 10:38

Hi,

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

thanks,

jp

bork · Post by **bork** » Mon 26 Apr 2010 13:54

Hello

I sent answer by E-mail.