ORA-30006 and distributed transaction

In distributed transaction I can't set timeout to more than 60 seconds using the following statement:

SELECT x FROM y_at_dblink FOR UPDATE WAIT n.

If rows in remote table are locked, and the value n <= 60, then this select works as expected: it fails with ORA-30006 after timeout of n seconds.

For any n > 60 the timeout does not exceed 60 seconds.

Is there any database or SQL*Net parameter that can cause this?

Thanks. Received on Fri Aug 08 2003 - 14:08:43 CDT