I have defined a variable which is TABLE TYPE of variable. This variable holds all of results which is of course like a table. Now I want to write store procedue to pull out the results from this variable. Then I want to define ref cursor which holds the results from this variable. Then I will pass OUT the ref cursor. Any idea or suggestions?
This variable defined like:
TYPE cust_tab IS TABLE OF cust_rec INDEX BY BINARY_INTEGER;
Thanks in advance.