// myscript.js

var oracledb = require('oracledb');


oracledb.createPool(
  {
    queueRequests : false,
    homogeneous : false,
    user: "c##api",
    password: "vdmtl",
    connectString : "localhost:1521/jeremie"
  },
  function(err,pool){
    pool.getConnection(
      {
        proxyUser: "c##api[c##jeremie]",
        // not required as anthony said
        //proxyUserPassword: "vdmtl"
      },
      function(err,connection)
      {
        connection.execute(
          `SELECT *
           FROM sys.people`,
          function(err, result)
          {
            if (err) {
              console.error(err.message);
              doRelease(connection);
              return;
            }
            console.log(result.rows);
            doRelease(connection);
          });
      });
  });

function doRelease(connection)
{
  connection.close(
    function(err) {
      if (err)
        console.error(err.message);
    });
}