oracledb library

Pure Dart Oracle Database driver implementing thin-mode TNS/TTC wire protocol.

This library provides Oracle database connectivity for Dart applications without requiring Oracle Client installation.

Classes

ColumnMetadata: Column metadata for a result set column.
OracleBatchError: A single row-level error collected by executeMany() when called with OracleExecuteManyOptions(batchErrors: true).
OracleBind: Specification for an OUT or IN OUT bind variable.
OracleBindDef: Metadata-only bind definition for OracleConnection.executeMany().
OracleCharsetInfo: Immutable description of the character sets a physical OracleConnection is talking to, detected once during connection startup (Story 10.1).
OracleConnection: A connection to an Oracle database.
OracleExecuteManyOptions: Per-call options for OracleConnection.executeMany.
OracleExecuteOptions: Per-call options for OracleConnection.execute.
OracleLob: A handle to a CLOB / NCLOB / BLOB value that reads and writes its data in bounded pieces, holding its connection open until closed.
OracleOutBinds: Container for output bind values returned by a PL/SQL execution.
OraclePool: A bounded pool of authenticated Oracle sessions.
OracleResult: The result of executing a SQL query.
OracleResultSet: A cursor-backed result set for incremental row consumption.
OracleRow: A single row from a query result.
OracleTimestampTz: An Oracle TIMESTAMP WITH TIME ZONE value that preserves the original time-zone offset alongside the absolute instant.
TlsConfig: Configuration for TLS/SSL connections to Oracle databases.

defaultLobStreamPieceSize → const int: Piece size (in the LOB's native units) that OracleLob.textStream and OracleLob.byteStream fall back to when the handle reports no server chunk size (chunkSize == 0).
oraBindMismatch → const int: Bind parameter error codes
oraBindTypeError → const int
oraConnectionClosed → const int: Connection lifecycle error codes
oraConnectionRefused → const int
oraConnectTimeout → const int
oraDataTypeNotSupported → const int: Inconsistent datatypes (ORA-00932). Also reported by the server when a cached SELECT cursor's column types changed under it (e.g. cross-session DDL); see oraVarNotInSelectList for the re-execute retry contract. Mirrors node-oracledb TNS_ERR_INCONSISTENT_DATA_TYPES.
oraHostUnreachable → const int
oraInvalidCredentials → const int: Authentication error codes (ORA-01017, ORA-28000, etc.)
oraMalformedPacket → const int: TNS:packet writer failure - malformed packet.
oraNetworkError → const int: Common Oracle TNS error codes used in the transport layer.
oraProtocolError → const int
oraProtocolViolation → const int: TNS:data truncation - protocol violation.
oraTlsCertificateError → const int
oraTlsHandshakeFailed → const int: TLS/SSL error codes
oraUnsupportedType → const int: Unsupported network datatype.

PoolSessionCallback = FutureOr<void> Function(OracleConnection connection, String requestedTag): Signature of the optional session callback accepted by OraclePool.create.