可以的! 这个是包内定义的 类型: TYPE DataSetRef IS REF CURSOR; 以下是存储过程: PROCEDURE pr_GetRejectFromSH(pDataSet OUT DataSetRef, vcReceivecode IN VARCHAR2) IS BEGIN OPEN pDataSet FOR select * from tbale1 where namecode like '%'||vcReceivecode||'%'; end pr_GetRejectFromSH;
这个是包内定义的 类型: TYPE DataSetRef IS REF CURSOR;
以下是存储过程:
PROCEDURE pr_GetRejectFromSH(pDataSet OUT DataSetRef,
vcReceivecode IN VARCHAR2) IS
BEGIN
OPEN pDataSet FOR select * from tbale1 where namecode like '%'||vcReceivecode||'%';
end pr_GetRejectFromSH;