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