Function returning REF CURSOR <p>I have package like this:</p> <pre><code>CREATE OR REPLACE PACKAGE product_package AS TYPE t_ref_cursor to IS REF CURSOR; FUNCTION get_products_ref_cursor RETURN t_ref_cursor; END product_package; CREATE OR REPLACE PACKAGE BODY product_package AS FUNCTION get_products_ref_cursor is RETURN t_ref_cursor IS products_ref_cursor t_ref_cursor; BEGIN OPEN products_ref_cursor FOR SELECT product_id, name, price FROM Products; RETURN products_ref_cursor; END get_products_ref_cursor; END product_package; </code></pre> <p>My question is, how can I use function <em>get_products_ref_cursor</em> (ref cursor) to get list of products?</p>