日期:2014-05-17 浏览次数:20747 次
create or replace package pkg_test is
procedure year_test(results_out out sys_refcursor,v_year in integer);
end pkg_test;
create or replace package body pkg_test is
procedure year_test(results_out out sys_refcursor, v_year in integer)
is
begin
open results_out for
with m as ( --这个临时表如果能事先建好,一句sql就可以了
select to_date(v_year
------解决方案--------------------