Problem with TOraSession & TOraStoredProc
Posted: 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
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