Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| AllowPreparedStatement | Prepare a query statement before its execution. |
| DirectQueryLimit | Specifies the maximum number of rows returned by queries in both Import and DirectQuery modes. |
| EnableForeignKeyDetection | Whether to detect the foreign keys in ODBC. |
| MaximumColumnSize | The maximum column size. |
| MaxLobSize | The maximum number of bytes to display in records for fields of LOB data types. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| NativeFolder | The path to the directory containing the native assemblies (.dll) the provider works with. |
| Other | Specifies advanced connection properties for specialized scenarios. Use this property only under the guidance of our Support team to address specific issues. |
| QueryPassthrough | This option passes the query to the Oracle OCI server as is. |
| Readonly | Toggles read-only access to Oracle OCI from the provider. |
| ReconnectTimeout | The sleep time, in seconds, before attempting reconnect to the server after exceeding the maximum idle time for a connection attempt. |
| ReconnectTries | The number of reconnection attempts that are made after exceeding the maximum idle time for an initial connection attempt. |
| ReturnCatalog | When set to False, this will return null for catalog when querying getCatalogs, getSchemas, getTables, getViews, getProcedures, getColumns, getProcedureParameters or getIndex. |
| RTK | Specifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. This property is only required in environments where the standard licensing method is unsupported or requires a runtime key. |
| SessionParameters | Used to specify additional session parameters after the initial connection has been established. |