Problem with TOraSession & TOraStoredProc

yousky · Post by **yousky** » Mon 02 Feb 2009 16:48

Hi Devart Team,

I've a problem with the TOraStoredProc & TOraSession for Delphi .NET 2006.

I want to execute a storedproc throw with those components and manage a timeout process. My TOraStoredProc has Nonblocking property equal to True.

What I want to do is if the procstroc execution time is greater than my timeout constant, I want to cancel the process but leave the process of my Storedproc alive on the Oracle server even if I close my application.

Is there a wait to do that ?

If not i've tried to disconnect the session from the server but seems to be blocked/freeze because my StoredProc call is not ended.

Do you have a solution to my problem ?

Library ODAC v5.80.0.40

Thanks
Greg

Challenger · Post by **Challenger** » Mon 09 Feb 2009 12:47

ODAC does not have such functionality.