Hi team,
We are trying to fetch email of some users from a table using pl/sql stored procedure. What we are trying to achieve is that ,in the handler section we are passing a variable called list (containing list of mails in the stored procedure) to a sys_refcursor variable called l_cursor and in the restful services we are providing the begin insert command like this:
declare l_cursor out SYS_REFCURSOR;
begin
RETRIEVDATA(list => l_cursor);
end;
Now my query is what to do with the l_cursor variable? Should we bind it with list? Which one will be the bind variable here, as I assume, l_cursor will be the bind variable. We did that and the other way round but it still gives HTTP 555 error.
Please suggest as to how can we fetch the emails through the GET API?