Forum Stats

  • 3,827,153 Users
  • 2,260,746 Discussions


node.js | oracledb - Query Help

edited Dec 22, 2016 1:11AM in Node.js

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'"