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;