node.js | oracledb - Query Help

78ee2038-e7be-4a6d-9340-c1cb73eeffa7

Hello All.

I needed to reach out for some help with the oracledb module for node.js. I'm attempting to pass in dynamic variables to bind variables using a form. I'm trying to test my setup and need to see the final SQL query string. I've been reading the documentation for the module, but haven't found what I needed.

Can someone help me understand how to console.log the complete execution query with bind variables in place?

For example, "SELECT * FROM TABLE_NAME WHERE IDENTIFIER = :first_name", ["John"]

I'd like to see the final query to prove my bind variable is working. So it should end up looking like... "SELECT * FROM TABLE_NAME WHERE IDENTIFIER = 'John'"

Christopher Jones-Oracle

This issues was also posted to https://github.com/oracle/node-oracledb/issues/575  where it is being followed up.