node-red-contrib-oracledb-mod 0.10.0

v0.10.0 - Multi-Node Transactions, Vector Search, Session Tracing, Schema Explorer

on Node.js NPM

Highlights

• Multi-Node Transaction Management: Support for multi-node atomic transactions with Begin, Continue, Commit, and Rollback modes via msg._oracleTx, complete with automatic 60-second safety rollback timer to guard against pool connection leaks.
• Oracle 23ai / 26ai Native Vector Search: Native binding of JavaScript Float32Array / Float64Array as oracledb.DB_TYPE_VECTOR for AI similarity queries (VECTOR_DISTANCE).
• Dynamic Observability & Session Tracing: Automatic session tagging in Oracle's V$SESSION and SYS_CONTEXT('USERENV', ...) via msg.action, msg.module, and msg.clientInfo, reflected in msg.oracle stats.
• Interactive Schema & Field Explorer: Full database hierarchy browser (Database → Schema → Object Type → Table/View → Fields) directly inside the query editor with smart SELECT *, SELECT cols, and INSERT template generation (automatically filtering out internal hidden SYS_NC$ and sequence identity columns).
• Expanded Test Suite: 36 automated tests (18 unit + 18 live Autonomous Database mTLS thin mode tests).