Node-oracledb 4.0 with Advanced Queuing and Oracle DB type and collection support

Christopher Jones-Oracle

Node-oracle 4.0 has been released on https://npmjs.com/package/oracledb

Release Announcement: https://blogs.oracle.com/opal/oracle-db-named-objects-and-advanced-queuing-support-new-in-node-oracledb-40

Top features: Querying and binding of named Oracle types; Oracle Advanced Queuing API; Oracle Implicit Results

Querying and binding of named Oracle types and collections is now supported in node-oracledb 4.0. It is easy to interact with user-defined and pre-supplied PL/SQL types, such as those in Oracle Spatial.  See https://oracle.github.io/node-oracledb/doc/api.html#objects

Oracle Advanced Queuing is a highly configurable and scalable messaging feature of Oracle Database. It has interfaces in various languages, letting you integrate multiple tools in your architecture to send and receive messages. Node-oracledb 4.0 has an Advanced Queuing API. See Oracle Advanced Queuing https://oracle.github.io/node-oracledb/doc/api.html#aq

Oracle Implicit Results allow queries in PL/SQL to be returned to applications without requiring REF CURSORS or bind variables. Node-oracledb 4.0 supports Implicit Results, further enhancing the developer experience with working with PL/SQL packages. See https://oracle.github.io/node-oracledb/doc/api.html#implicitresults

Other features and fixes also landed in node-oracledb 4.0, see the CHANGELOG https://github.com/oracle/node-oracledb/blob/master/CHANGELOG.md

RESOURCES

Installation: https://www.npmjs.com/package/oracledb

User Guide: https://oracle.github.io/node-oracledb/doc/api.html

Issues and questions: https://github.com/oracle/node-oracledb/issues