不明白你的意识,是返回游标吗? 给你个存储过程返回游标的例,你看看。 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;
给你个存储过程返回游标的例,你看看。
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;