CREATE OR REPLACE PROCEDURE I_INMS_SITE_DAY(IN_USERID IN VARCHAR2,
IN_AREAID IN VARCHAR2,
OUT_CURSOR OUT SYS_REFCURSOR) IS
i_year VARCHAR2(100);
i_month VARCHAR2(100);
i_code VARCHAR2(32);
i_name VARCHAR2(100);
i_count NUMBER;
i_first NUMBER;
i_second NUMBER;
i_third NUMBER;
i_fourth NUMBER;
i_fifth NUMBER;
i_sixth NUMBER;
i_seventh NUMBER;
i_eighth NUMBER;
i_ninth NUMBER;
i_tenth NUMBER;
i_eleventh NUMBER;
i_twelfth NUMBER;
i_thirteenth NUMBER;
i_fourteenth NUMBER;
i_fifteenth NUMBER;
i_sixteenth NUMBER;
i_seventeenth NUMBER;
i_eighteenth NUMBER;
i_nineteenth NUMBER;
i_twentieth NUMBER;
i_twenty_first NUMBER;
i_twenty_second NUMBER;
i_twenty_third NUMBER;
i_twenty_fourth NUMBER;
i_twenty_fifth NUMBER;
i_twenty_sixth NUMBER;
i_twenty_seventh NUMBER;
i_twenty_eighth NUMBER;
i_twenty_ninth NUMBER;
i_thirtieth NUMBER;
i_thirty_first NUMBER;
CURSOR C_INMS_SITE_DAY IS
select to_char(t.create_date, 'YYYY') into i_year,
to_char(t.create_date, 'MM') into i_month,
a.code into i_code,
a.name into i_name,
count(*) into i_count,
decode(to_char(t.create_date, 'DD'), '1', count(*), 0) "1" into i_first,
decode(to_char(t.create_date, 'DD'), '2', count(*), 0) "2" into i_second,
decode(to_char(t.create_date, 'DD'), '3', count(*), 0) "3" into i_third,
decode(to_char(t.create_date, 'DD'), '4', count(*), 0) "4" into i_fourth,
decode(to_char(t.create_date, 'DD'), '5', count(*), 0) "5" into i_fifth,
decode(to_char(t.create_date, 'DD'), '6', count(*), 0) "6" into i_sixth,
decode(to_char(t.create_date, 'DD'), '7', count(*), 0) "7" into i_seventh,
decode(to_char(t.create_date, 'DD'), '8', count(*), 0) "8" into i_eighth,
decode(to_char(t.create_date, 'DD'), '9', count(*), 0) "9" into i_ninth,
decode(to_char(t.create_date, 'DD'), '10', count(*), 0) "10" into i_tenth,
decode(to_char(t.create_date, 'DD'), '11', count(*), 0) "11" into i_eleventh,
decode(to_char(t.create_date, 'DD'), '12', count(*), 0) "12" into i_twelfth,
decode(to_char(t.create_date, 'DD'), '13', count(*), 0) "13" into i_thirteenth,
decode(to_char(t.create_date, 'DD'), '14', count(*), 0) "14" into i_fourteenth,
decode(to_char(t.create_date, 'DD'), '15', count(*), 0) "15" into i_fifteenth,
decode(to_char(t.create_date, 'DD'), '16', count(*), 0) "16" into i_sixteenth,
decode(to_char(t.create_date, 'DD'), '17', count(*), 0) "17" into i_seventeenth,
decode(to_char(t.create_date, 'DD'), '18', count(*), 0) "18" into i_eighteenth,
decode(to_char(t.create_date, 'DD'), '19', count(*), 0) "19" into i_nineteenth,
decode(to_char(t.create_date, 'DD'), '20', count(*), 0) "20" into i_twentieth,
decode(to_char(t.create_date, 'DD'), '21', count(*), 0) "21" into i_twenty_first,
decode(to_char(t.create_date, 'DD'), '22', count(*), 0) "22" into i_twenty_second,
decode(to_char(t.create_date, 'DD'), '23', count(*), 0) "23" into i_twenty_third,
详细解决方案
存储过程报错,求解,该如何处理
热度:107 发布时间:2016-04-24 06:39:39.0
相关解决方案