Forum Stats

  • 3,741,756 Users
  • 2,248,473 Discussions
  • 7,861,976 Comments

Discussions

node.js | oracledb - Query Help

78ee2038-e7be-4a6d-9340-c1cb73eeffa7
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'"

Answers

Sign In or Register to comment.