You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: