SQLDatabaseMBS - Oracle - Timeout set to -1

Databases
1

Hi,

is there a way to set the timeout for an Oracle connection using SQLDatabaseMBS to -1?

2

For Oracle, I can find:

OCI_ATTR_RECEIVE_TIMEOUT

OCI_ATTR_SEND_TIMEOUT

Connection Scope

Undocumented OCI attributes allow to specify connection socket timeouts.

Valid values: the string representing timeout value (in milliseconds)

Default value: none

and

UseSessionPool_Timeout

Connection Scope

Specifies the session pool OCI_ATTR_SPOOL_TIMEOUT attribute value.

Valid values: String containing the timeout value (in seconds)

You could set them in Xojo:

db.Option("OCI_ATTR_RECEIVE_TIMEOUT") = "30000"
db.Option("OCI_ATTR_SEND_TIMEOUT") = "30000"
3

thank you!