Added #

• Initial stable release

• Connection Management

  • Direct connections with OracleConfig.create()
  • Environment-based configuration with OracleConfig.fromEnvironment()
  • Connection pooling with configurable min/max connections
  • Connection health checks with ping()

• Query Execution

  • Parameterized queries with positional (?, :1) and named (:name) parameters
  • Streaming results with rows() for memory-efficient large result sets
  • Batch operations with executemany() for high-performance bulk inserts
  • Prefetch configuration for query optimization

• Transaction Support

  • Manual commit/rollback control
  • Autocommit mode
  • Transaction isolation levels (READ COMMITTED, SERIALIZABLE, READ ONLY)

• Stored Procedures

  • Call procedures with callproc()
  • IN, OUT, and INOUT parameter support
  • REF CURSOR support for returning result sets

• LOB Support

  • CLOB, BLOB, NCLOB read/write operations
  • Buffered LOB operations for performance
  • setFromBytes() for efficient bulk writes

• Data Types

  • Full support for VARCHAR2, NUMBER, DATE, TIMESTAMP
  • INTERVAL DAY TO SECOND and INTERVAL YEAR TO MONTH
  • ROWID retrieval and usage
  • UTF-8 international character support

• Error Handling

  • Comprehensive exception hierarchy
  • OracleStatementException with SQL context
  • OracleConnectionException with connection details
  • Oracle error codes preserved

• Developer Experience

  • 13 complete example files
  • 104 tests (59 unit + 45 integration)
  • Comprehensive README documentation

Dependencies #

• Requires Oracle Instant Client (free download from Oracle)
• Dart SDK ^3.7.0