ORACLE 存储过程的一点疑问
CREATE OR REPLACE PROCEDURE APP_MANAGER.PB_EQUIP_SUBMIT(Y IN VARCHAR2,M IN VARCHAR2) AS
CURSOR CS IS
SELECT FACILITY_NO
,DEPRECIATION_THIS_MONTH
,SERVICE_LIFE
,UNUSED_LIFE
,ACCUMULATIVE_DEPRECIATION
,CURRENT_VALUE
FROM APP_MANAGER.SB_DEPRECIATION_2019
WHERE SEQ_ID LIKE '%'||Y||M;
BEGIN
FOR C IN CS LOOP
BEGIN
UPDATE APP_MANAGER.ASSET_EQUIP_FACILITY
SET DEPRECIATION_THIS_MONTH = C.DEPRECIATION_THIS_MONTH
,SERVICE_LIFE = C.SERVICE_LIFE
,ACCUMULATIVE_DEPRECIATION = C.ACCUMULATIVE_DEPRECIATION
,CURRENT_VALUE = C.CURRENT_VALUE
WHERE FACILITY_NO = C.FACILITY_NO;
END;
END LOOP;
END PB_EQUIP_SUBMIT;
现在这个存储过程是可以运行的。
参数Y是年,M是月,我上面有个2019是写死的,我想把2019替换成Y,如何实现呢??求完整代码。