Hi,
We are building a rest api with Oracle Database 19c, NodeJS 17.3.1, and oracledb 5.5.0.
There is a minor problem however, please see code.
...
const result = await connection.execute(
`SELECT id, name, address FROM customers
WHERE id = :id`,
{
id: { type: oracledb.NUMBER, dir: oracledb.BIND_IN, val : 123 }, <-- hard-coded works, but when sending the value via req.params.id nothing is returned
{ outFormat: oracledb.OUT_FORMAT_OBJECT }
}
);
console.log(result.rows);
...
Furthermore, we have a lot of business logic in packages and need to call a procedure or function through the rest api. Can someone provide examples.
Thanks!