Re: how to specify timeout in connectionstring????????

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 26 Jul 2005 20:07:16 +0100
Message-ID: <cs1de1p8g9f1kt03740vjajvrc4t9k5cru@4ax.com>

On 26 Jul 2005 10:16:31 -0700, "db" <deepakbadki_at_rediffmail.com> wrote:

>In sql, we can specify timeout attribute in connection string. In the
>similar way , does oracle allow to specify timeour parameter in
>connection string?.........If yes then plse let me know the connection
>string with timeout attribute.

Not as far as I'm aware, but you may want to look at SQLNET.INBOUND_CONNECT_TIMEOUT in sqlnet.ora.

http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#sthref481

Or at the OCI level, you could presumably use OCIBreak in a SIGALRM handler.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Tue Jul 26 2005 - 14:07:16 CDT