Recent content by ChrisG

Marco If this is an Oracle Bug, can you provide details of the bug so we can chase this matter with Oracle please? Many thanks Christopher

Marco Has there been any update on this? Regards Christopher

Marco I've now tried against a 9.2.0.5 server, and the problem is still present. We are still having to unload our IIS application at regular intervals to combat the memory leak. Any further suggestions welcome. Regards Christopher

Thanks Marco. We hope to upgrade to 9.2.0.5 soon. Have you tried that version? If it is specific to certain Oracle versions, maybe that will solve it. However, if it is an Oracle bug, I am unsure how to raise this with Oracle, as I cannot see a way to reproduce the error without using DOA. I...

Marco Can you let me know what configuration you used that works okay? This may help us. Regards Christopher

Hi Marco. Any update?

Hello Marco, thanks for the feedback. I'm using Delphi 5 with DOA 4.0.5 Oracle server version 9.2.0.4.0 Oracle client version 9.2.0.1.0 All on Windows NT 4 platform.

Hi Marco. Hope you received my demo project ok. Any ideas? Thanks Christopher

Demo project and stored procs sent as requested. To summarise: Delphi would appear to be unable to free the temporary LOB, only when all the following are true:- 1) OracleQuery calls a stored proc which calls another 2) Both stored procs have a CLOB input parameter 3) Both stored procs evaluate...

Yes. The TOracleQuery.Session.Connected property is still true at this point.

Here is my code: try myCLOB.Free; except on E: EOracleError do begin LogAction('Save Dealer Exception - Unable to free Temporary CLOB'+#13#10+ 'mess='+e.Message+' num='+FloatToStr(E.ErrorCode)); end; end; and here is an extract from my log file: 29/06/2004 10:42:57 Save Dealer...

1. Have downloaded DOA 4.0.5 - Same problem occurs. 2. Although exception message is blank, if I use EOracleError the exception numbers raised are:- 32550540, 33070844, 32554684, 32553312 If I "unload" my delphi app from IIS and try again I get the same sequence of error numbers(!)

It's very strange. There is an exception, it is captured by the exception handler, however there is NO message. (i.e. E.message="")

Hi I'm experiencing problems when freeing a temporary TLobLocator at certain times. My TOracleQuery calls a stored proc which has a CLOB parameter for saving data. The stored proc then calls another stored proc and passes the CLOB parameter through. It would appear that when the parameter in...