oracle返回数据集，用于查询

1)建包

CREATE OR REPLACE PACKAGE PKG_SELECT_STUDENT
AS
   TYPE T_CURSOR IS REF CURSOR;
   PROCEDURE Getusername  
   (
      us_id IN Varchar2,
      cur_name OUT T_CURSOR
   );

2）包体

CREATE OR REPLACE   PACKAGE　BODY PKG_SELECT_STUDENT
AS
PROCEDURE Getusername
(
us_id IN varchar2,
cur_name OUT T_CURSOR
   )
   IS
   BEGIN
      OPEN cur_name FOR
      SELECT   *   FROM student WHERE   studentid=us_id;
   END Getusername;
   END PKG_select_student;