node-jdbc icon indicating copy to clipboard operation
node-jdbc copied to clipboard

Can't call a function ?

Open richardnassar-external opened this issue 5 years ago • 0 comments

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.

richardnassar-external avatar Jul 26 '19 13:07 richardnassar-external