Page 1 of 1

[OCL] Connection setTimeout

Posted: Mon 03 Aug 2009 08:16
by PETER_99
[OCL] Connection setTimeout

I have some problem for use OCL.
When program try to call stored procedure(SP), if SP is long time no response.
my program always waiting for SP response(almost dead).

So, my question is : how can I set time out when SP long time no response??
I hope use OCL function to solve this question.
thanks. :oops:

my program:
==============================================
Conn->startTransaction();
OraCommand Cmd(*Conn);
Cmd.setCommandText("sploop");
Cmd.setCommandType(ctStoredProc);
Cmd.param("inCID").setChars(QA_CID);
Cmd.execute(); // if long time no response?? how can i do ??
==============================================