OCI timeout question

Hi,

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

I tried using the timeout parameter of the OCITransStart() function, but no [Quoted] 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 CEST