node-jdbc
node-jdbc copied to clipboard
Can't call a function ?
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.