Hi,
below is the javascript which I am trying to call but getting error.
Kindly help me
const oracle = require('oracle');
const connection = oracle.createConnection({
host: '',
port:'',
user: '',
password: '',
servicename: ''
});
connection.connect();
const myProcedure = "CALL SPNAME(parameter1, parameter2, @return_code); SELECT @return_code;";
connection.query(myProcedure, u'?', '?'], (err, rows) => {
if (err) {
throw err;
}
const outputParam = rowsr1] 0]r'@return_code'];
console.log(outputParam);
});
connection.end();