oracle怎么执行包的存储过程

oracle如何执行包的存储过程现有包CREATE OR REPLACE PACKAGE PKG_AllConsumeBlock isTYPE myrctype IS RE

oracle如何执行包的存储过程
现有包
CREATE OR REPLACE PACKAGE PKG_AllConsumeBlock is
  TYPE myrctype IS REF CURSOR; 
  PROCEDURE usp_AllConsumeBlock(cur_out OUT myrctype,StartMth char,FinishiMth char);
end PKG_AllConsumeBlock;

包体
CREATE OR REPLACE PACKAGE BODY PKG_AllConsumeBlock AS  
  PROCEDURE usp_AllConsumeBlock
  (
  cur_out OUT myrctype,StartMth char,FinishiMth char
  )
  IS
  BEGIN
OPEN cur_out FOR
  SELECT * from 表名 where 条件 ;
  END usp_AllConsumeBlock;  
END PKG_AllConsumeBlock;

请问该如何调用来进行查询?谢谢各位了


[解决办法]

探讨
引用:

SQL> var c refcursor
SQL> begin
2    PKG_AllConsumeBlock.PROCEDURE usp_AllConsumeBlock(:c, para1, para2);
3  end;
4  /

PL/SQL procedure successfully completed.

SQL> print :c


还是没看懂,能解释一下上面的代码吗?

我的异常网推荐解决方案:oracle存储过程,http://www.myexception.cn/oracle-develop/177537.html