游标使用select 的参数问题
CREATE OR REPLACE
procedure UpdateSHGL_CJForDate(
i_cjrq in date
)
as
-------------------------
cursor dataForDate isselect HM,HMLB,BDHF,BDCT,BDGJ,YHL from SHGL_CJQD
where CJRQ=changedDate;
这个changedDate是i_cjrq的处理,可是是我现在想在定义游标之前用
---------------------------
select to_char(i_cjrq,'YYYY-MM') into changeStrDate from dual;
select to_date(changeStrDate,'YYYY-MM') into changedDate from dual;
-------------------------------
对i_cjrq进行处理怎么办一得到changedDate??怎么办谢谢!!!!