OracleBind class

Specification for an OUT or IN OUT bind variable.

Use OracleBind.out for a pure OUT parameter (procedure or function return) and OracleBind.inOut for a parameter that takes an input value and may have it modified by the procedure:

final result = await connection.execute(
  'BEGIN story_increment(:value); END;',
  {'value': OracleBind.inOut(value: 41, type: OracleDbType.number)},
);
expect(result.outBinds['value'], equals(42));

For OracleDbType.varchar and OracleDbType.raw, callers must supply maxSize so the server allocates a return buffer large enough for the returned value.

OracleDbType.timestampTz OUT / IN OUT values follow the connection's column-decode contract: a plain UTC DateTime by default, or an OracleTimestampTz carrying the server-sent offset on a connection opened with preserveTimestampTimeZone: true.

Constructors

OracleBind.inOut({required Object? value, required OracleDbType type, int? maxSize})
Declares an IN OUT bind: sends value to the server and reads the (possibly modified) value back through OracleResult.outBinds.
OracleBind.out({required OracleDbType type, int? maxSize})
Declares an OUT-only bind for the given Oracle type.

Properties

direction → BindDir
Direction on the wire. Only BindDir.output and BindDir.inputOutput are produced by the public constructors; BindDir.input binds are supplied as raw Dart values, not OracleBind instances.
final
hashCode → int
The hash code for this object.
no setterinherited
maxSize → int?
Maximum returned-value bound (required for varchar/nVarchar/raw/clob/nClob/blob/json).
final
oracleTypeCode → int
The Oracle wire-protocol type indicator for type.
no setter
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
type → OracleDbType
The Oracle type expected on the wire.
final
value → Object?
Input value sent to the server. null for OUT-only binds.
final

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited