赞
踩
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;
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。