I'm trying to call a function from oracle in nodejs... I tried calling a query this way :
statement.executeQuery( select P_points_mgmt.f_upd_rec(${CLIENT_CODE}, ${status}) from dual, (executeErr, resultset) => {
if (executeErr) {
logger.error(Execution Error: ${executeErr});
} else {
resultset.toObjArray((err, results) => {
logger.info(JSON.stringify(results));
});
}
}
It's working fine but when i want to call a function it's not.
what is the proper way to call a function ?? I tried select fctNamr from dual did not work also tried without from dual.
I'm trying to call a function from oracle in nodejs... I tried calling a query this way : statement.executeQuery(
select P_points_mgmt.f_upd_rec(${CLIENT_CODE}, ${status}) from dual, (executeErr, resultset) => { if (executeErr) { logger.error(Execution Error: ${executeErr}); } else { resultset.toObjArray((err, results) => { logger.info(JSON.stringify(results)); }); } }It's working fine but when i want to call a function it's not. what is the proper way to call a function ?? I tried select fctNamr from dual did not work also tried without from dual.