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

    cj

      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