Oratcl

Oratcl is a Tcl extension providing access to an Oracle Database server via the Oracle Call Interface (OCI) — login, SQL/PL-SQL execution, row-oriented fetch, bind variables, LOB read/write, transactions, and TAF failover callbacks, all as native Tcl commands.

Latest release: 5.0 (2026-10-18)

Oratcl 5.0 is a major modernization release:

• Tcl 9 support — full port to Tcl 9's new Tcl_Size API, stricter variable scoping, and stub mechanism, while remaining source-compatible with Tcl 8.6.
• Oracle 23c compatibility — updated OCI constants/types for the 23.3 SDK, fixed array-DML/cursor-reuse behavior changed in 23c, verified end-to-end against a live Oracle 23c (XE) database (169/169 tests passing on Linux).
• New oralob2 command — direct OCI-level LOB read via OCILobRead2, avoiding the older DBMS_LOB PL/SQL-wrapper path used by oralob.
• Security hardening — fixed a stack buffer overflow and Tcl script-injection bug in the TAF failover callback, scrubbed connect strings from freed heap memory, added bounds checking on oraconfig fetchrows to prevent integer overflow.
• Modernized build — ANSI C prototypes throughout (C23-compatible), TEA 3.13, dropped pre-Tcl-8.4/CVS-era compatibility cruft.

Downloads

• oratcl-5.0.tar.gz — source (Linux, macOS, or any Unix-like platform with Tcl 9/8.6 and an Oracle Instant Client SDK)
• Oratcl50-Darwin-arm64.zip — prebuilt macOS (Apple Silicon) binary
• Oratcl50-Windows-x64.zip — prebuilt Windows x64 binary (built via mingw-w64 cross-compile, no MSVC/Oracle SDK required to build)

All three have been runtime-verified against a live Oracle 23c database.

Full details: see CHANGELOG.md (github.com) and the 5.0 GitHub release.