Refcursor

A nice and simple one today, but something that comes up quite frequently.

In isolation, how can I test/see the results of my stored procedure which returns a refcursor?


var r refcursor
set autoprint on
exec myproc(:r)


And that’s all folks….

About these ads