Cmdlets for Oracle

Build 24.0.9060

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.


PropertyDescription
AllowPreparedStatementPrepare a query statement before its execution.
MaxLobSizeThe volume in numbers of bytes or UTF-8 chars which is allowed to query by non-parameterized SELECT query.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
NativeFolderThe path to the directory containing the native dlls the provider works with. This property is effective on the Windows and macOS platforms only.
OtherThese hidden properties are used only in specific use cases.
QueryPassthroughThis option passes the query to the Oracle OCI server as is.
ReadonlyYou can use this property to enforce read-only access to Oracle OCI from the provider.
ReconnectTimeoutThe sleep time, in seconds, before retrying to reconnect to the server on a maximum idle time exceeded error.
ReconnectTriesThe number of retry to connect server when a maximum idle time exceeded error is reported by server.
RTKThe runtime key used for licensing.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060
 

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060