Creating a package
From WickyWiki
CREATE OR REPLACE PACKAGE cursors_pkg IS TYPE refcursortype IS REF CURSOR; FUNCTION getusers RETURN refcursortype; END; / CREATE OR REPLACE PACKAGE BODY cursors_pkg IS FUNCTION getusers RETURN refcursortype IS alluserscursor refcursortype; BEGIN OPEN alluserscursor FOR SELECT username , user_id , created FROM all_users; RETURN alluserscursor; END; END;