You just need a script that calls your stored procedure and has a bind variable for the ref cursor output to display it in TOAD’s grid in the Editor window.
type result_set is ref cursor;
When you then run this TOAD will prompt you to ‘bind’ :result_set, just select ref cursor from the list of types and then the result will display in the grid. The trick is to think of yourself as a ‘client’ calling your stored procedure and you need your own ref cursor to store the result. If you just looking for a way to invoke the SP, then the Oracle way is: