Forum Stats

  • 3,757,175 Users
  • 2,251,204 Discussions
  • 7,869,751 Comments

Discussions

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

Christopher Jones-Oracle
Christopher Jones-Oracle Member Posts: 1,638 Employee
edited Jul 25, 2019 7:35AM in Node.js

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

Tagged: