Interface for the options used in executeMany().

Hierarchy

  • IExecuteManyOptions

Properties

The bindDefs object defines the bind variable types, sizes and directions. This object is optional, but makes execution more efficient if set explicitly.

It must be an array (see ArrayBindDefs) or an object (see IObjectBindDefs), depending on the structure of the binds parameter.

Each value in the bindDefs array or object must be an object containing the keys dir, maxSize, and type for each bind variable, similar to how execute bind parameters are defined (see IBindDef).

dmlRowCounts?: boolean
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