Given a pl/sql procedure that looks similar to the example provided below,
const result = await connection.execute(
`BEGIN
:ret := no_func(:p1, :p2, :p3);
END;`,
{
p1: 'Chris', // Bind type is determined from the data. Default direction is BIND_IN.
p2: 'Jones',
p3: { dir: oracledb.BIND_OUT, type: oracledb.NUMBER },
ret: { dir: oracledb.BIND_OUT, type: oracledb.STRING, maxSize: 40 }
});
console.log(result.outBinds);
My task is to continuously call the procedure until there are no records left. What is the response of result.outBinds in that case? (or) what condition do I add to the loop to keep invoking the procedure until there are none left?
Help would be much appreciated. Thanks in advance.
New contributor
Harshini Lakshmi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.