const oracledb = require('oracledb');

let query=`UPDATE TABELA
           SET COL1=:info1, COL2=:info2, COL3=:info3, COL4=:info4
           WHERE ID=:id_col`

let connection = {
    user:'user'||process.env.NODE_ORACLE_USER,
    password:'password'||process.env.NODE_ORACLE_PASSWORD,
    connectString:'connectSring'||process.env.NODE_ORACLE_CONNECTIONSTRING
}

let info = {
   in1:true,
   in2:'word'
   in3:'word'
   in4:'word'
   id:6
}

let putStatement =()=> oracledb.getConnection(connection, (err, conn)=>{
    err? alert(err.message):
    conn.execute(query,[info.in1, info.in2, info.in3,info.in4,info.id],{
        autoCommit: true,
        outFormat: oracledb.OBJECT
    },(err, result)=> {
        err? alert(err.message):
        alert(result.rowsAffected)
    }
});

putStatement();