I want to call the stored procedure using JavaScript in AA

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, ['?', '?'], (err, rows) => {
  if (err) {
    throw err;
  }

  const outputParam = rows[1][0]['@return_code'];
  console.log(outputParam);
});

connection.end();