The other day at work while I was troubleshooting a problem I needed to execute a stored proc that used a IN/OUT ref cursor. I had never did this before. So after spending some time googling, I figured out it is not as complicated after all. So here it goes for all those people who are looking to do the same:
variable myVar refcursor;
Hope this helps out…..