DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query/SQL command timeout

651664Jul 23 2008 — edited Aug 12 2008

Greetings,

I am writing an interface to a product using OCI API's. I have a question about designing this interface.

If we are able to successfully establish connection with Oracle databae and
the query takes long time to execute/OCIStmtExecute(), is there any way to timeout the query and return ?

Can we set a timeout parameter using OCI API's or Oracle instant client configuration files ?

Earlier posts in the forums reveals that there may be no such parameter. I believe this is a fairly common problem and there must be some solution for this or do I need to install any oracle patch ?

Best Regards
Murthy

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 9 2008

Added on Jul 23 2008

#oracle-call-interface-oci

8 comments

4,738 views