一、先在 Oracle 建包 CREATE OR REPLACE PACKAGE pkg_test AS TYPE myrctype IS REF CURSOR; PROCEDURE get(i_test INTEGER,p_rc OUT myrctype); END pkg_test;
CREATE OR REPLACE PACKAGE BODY pkg_test AS PROCEDURE get(i_test INTEGER,p_rc OUT myrctype) IS BEGIN IF i_test = 0 THEN OPEN p_rc FORSELECT SYSDATE FROM dual; ELSE OPEN p_rc FORSELECT * FROM tab; END IF; END get; END pkg_test;