Creating a package

From WickyWiki
Revision as of 07:26, 5 July 2013 by Admin (talk | contribs) (3 revisions)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;