Node-oracledb 6.3 introduces support for Oracle Database warnings, enhanced XMLType support in Thin mode and much more

Sharad Chandran
Oracle Developers
Published in
2 min readDec 21, 2023
Photo by Markus Spiske on Unsplash

Release announcement: A new release of node-oracledb, the Node.js and TypeScript module for accessing Oracle Database, is available from npm.

Top features: Support for Oracle Database (ORA) warnings, Improved XMLType support in Thin mode, New connection object properties

The node-oracledb 6.3 is our most complete release yet with a host of new features including support for Oracle Database warnings, enhanced XMLType data fetching and new connection and metadata attributes.

The node-oracledb module now provides a warning property to detect “SUCCESS WITH INFO” warnings such as a password being in its grace period and PL/SQL compilation failures that are thrown by the Oracle Database. This helps application users to efficiently write code to handle these conditions.

We have also added support for fetching XMLType data of any length as strings in Thin mode, which effectively simplifies code and improves data fetching.

New connection properties connection.dbDomain, connection.dbName, connection.maxOpenCursors , connection.serviceName and connection.transactionInProgress provide visibility into connection environment and state.

The SQL domain and annotation properties domainName , domainSchema and annotations introduced in this release provide node-oracledb applications with support for the Oracle Database 23c domain and annotations features.

In addition, we have improved the external authentication support and fixed multiple internal and external issues raised by our GitHub users.

See the latest Release Notes for all the changes.

Installing or Upgrading node-oracledb

You can install or upgrade node-oracledb by updating your package.json requirements:

"dependencies": {
"oracledb": "^6.3"
},

Resources

Finally, contributions to node-oracledb are more than welcome, see CONTRIBUTING.

--

--

Sharad Chandran
Oracle Developers

Sharad Chandran is a Principal Product Manager at Oracle working on building client-side interfaces & APIs for the Oracle DB in C/C++, Python, Node.js, Go etc.