Interface IExecuteOptions

Interface for options used in execute().

Hierarchy

  • IExecuteOptions

Properties

extendedMetaData? fetchArraySize? fetchInfo? fetchTypeHandler? keepInStmtCache? maxRows? outFormat? resultSet?

Properties

Optional extendedMetaData

extendedMetaData?: boolean

Overrides parameters.extendedMetaData.

Optional fetchArraySize

fetchArraySize?: number

Overrides parameters.fetchArraySize.

Optional fetchInfo

fetchInfo?: IFetchInfo

Object defining how query column data should be represented in JavaScript. It can be used in conjunction with, or instead of, the global settings parameters.fetchAsString, parameters.fetchAsPlsqlWrapper, and parameters.fetchAsUint8Array. See https://github.com/oracle/node-oracledb/blob/v3.1.0/doc/api.md#--42634-fetchinfo for further information.

Optional fetchTypeHandler

fetchTypeHandler?: FetchTypeHandler

Overrides parameters.fetchTypeHandler.

Since

Oracle 23.7

Optional keepInStmtCache

keepInStmtCache?: boolean

When keepInStmtCache is true, and statement caching is enabled, then the statement will be added to the cache if it is not already present. This helps the performance of re-executed statements.

The default value is true.

Since

Oracle 23.4

Optional maxRows

maxRows?: number

Overrides parameters.maxRows.

Optional outFormat

outFormat?: number

Overrides parameters.outFormat.

Optional resultSet

resultSet?: boolean

Determines whether query results should be returned as a IResultSet object or directly. The default is false.

Settings

Member Visibility

Theme