0 Replies Latest reply on Jul 25, 2019 11:35 AM by cj

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


      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




      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