how to pass sysrefcursor as a parameter to oracle scheduler job

Question

I'm getting a SYSREFCUROSOR as output parameter from a stored procedure, How to call that SP in a oracle scheduler job and pass that parameter?

Answer 1

If you are discarding the ref cursor then create a wrapper procedure that does that; something like:

create procedure wrapper_proc as
  l_refcursor sys_refcursor;
begin
  orig_proc(l_refcursor);
  close l_refcursor;
end;
/

And then call the wrapper procedure in your scheduled job instead.