如何在 Oracle SQL Developer中执行返回类型为游标的存储过程?
猿来是我 2010-11-23 12:36:12 package上右键菜单Run,
DECLARE
STARTDATE DATE;
CUR_DATA DBOPT.PKG1.cursorType;
BEGIN
STARTDATE := to_date('1/1/2007','mm/dd/yyyy');
PKG1.GETGAMEINFO(
STARTDATE => STARTDATE ,
CUR_DATA => CUR_DATA
);
-- Modify the code to output the variable
DBMS_OUTPUT.PUT_LINE(CUR_DATA.CategoryName);
END;
其中,cursorType的声明为:
type cursorType is ref cursor;
错误提示: Invalid reference to variable 'CUR_DATA'
如何执行这个存储过程,得到结果集??