Forum Stats

  • 3,741,776 Users
  • 2,248,475 Discussions
  • 7,861,987 Comments

Discussions

bind parameters as an array of objects

User514049-Oracle
User514049-Oracle Member Posts: 68
edited May 7, 2017 8:59PM in Node.js

All:

Is it possible to pass an array of bind variables i.e. w/o names, just as positional objects?

 "INSERT INTO countries VALUES (:country_id, :country_name)",  {  country_id: { val: 90, dir: oracledb.BIND_IN, type: oracledb.NUMBER },  country_name: { val: "Tonga", dir: oracledb.BIND_IN, type:oracledb.STRING }  }  [     { val: 90, dir: oracledb.BIND_IN, type: oracledb.NUMBER },     { val: "Tonga", dir: oracledb.BIND_IN, type:oracledb.STRING }  ]

Some specifications like ODBC/JDBC support ? as bind parameter marker -- insert into countries values(?.?).   It will be useful in such cases.

With regards

Answers

Sign In or Register to comment.