OCI timeout question

From: Erika <erika_at_no_spam.com>
Date: 2000/05/25
Message-ID: <392D9438.879B1B84@no_spam.com>#1/1

Hi,

I'm trying to specify the amount of time an OCIStmtExecute() should attempt to execute a write to the database before it gives up. I have a test case where I am forcing a timeout error to occur (I write to the table in sqlplus and do _not_ commit -- my program shows a timeout error after 60 seconds). I need to be able to have it timeout after 10 seconds.

I tried using the timeout parameter of the OCITransStart() function, but no matter what I set it to - it always times out in ~60 seconds.

Is there a way to set the timeout time in either OCI or in the db server itself?

Thanks!

Erika Received on Thu May 25 2000 - 00:00:00 CDT