rt
------解决方案--------------------
不明白你的意识,是返回游标吗?
给你个存储过程返回游标的例,你看看。
CREATE OR REPLACE PACKAGE pkg_test
AS
TYPE myrctype IS REF CURSOR;
PROCEDURE get(p_rc OUT myrctype);
END pkg_test;
/
CREATE OR REPLACE PACKAGE BODY pkg_test
AS
PROCEDURE get( p_rc OUT myrctype)
IS
sqlstr VARCHAR2 (500);
BEGIN
sqlstr:=v`/`vselect id,name from deptv`/`v;
OPEN p_rc FOR sqlstr;
END get;
END pkg_test;