大虾们好! 写存储过程中遇到一个问题 请大家帮帮看看一下 怎么解决CREATE OR REPLACE PROCEDURE pr_temp
IS
truncate TABLE tb_sms_unsend_temp;
COMMIT;
INSERT INTO tb_sms_unsend_temp(iid,phone,area_id,service_code,status_id,delivery_timestamp,str_day)
SELECT ('UN'||to_char(sysdate,'yyyymmddhh24miss')||ROWNUM),phone,fn_get_areaidbyphone(phone),service_code,
status_id,delivery_timestamp,str_day FROM tb_sms_detail WHERE
to_char(SYSDATE - interval '1' DAY,'yyyymmdd')<=to_char(start_timestamp,'yyyymmdd') AND
status_id<>'1000';
COMMIT;
END pr_temporacle提示错误 :
Error: PLS-00201: 必须说明标识符 'NUMTODSINTERVAL'
Line: 15
Text: to_char(SYSDATE - INTERVAL '1' DAY,'yyyymmdd')<=to_char(start_timestamp,'yyyymmdd') AND
IS
truncate TABLE tb_sms_unsend_temp;
COMMIT;
INSERT INTO tb_sms_unsend_temp(iid,phone,area_id,service_code,status_id,delivery_timestamp,str_day)
SELECT ('UN'||to_char(sysdate,'yyyymmddhh24miss')||ROWNUM),phone,fn_get_areaidbyphone(phone),service_code,
status_id,delivery_timestamp,str_day FROM tb_sms_detail WHERE
to_char(SYSDATE - interval '1' DAY,'yyyymmdd')<=to_char(start_timestamp,'yyyymmdd') AND
status_id<>'1000';
COMMIT;
END pr_temporacle提示错误 :
Error: PLS-00201: 必须说明标识符 'NUMTODSINTERVAL'
Line: 15
Text: to_char(SYSDATE - INTERVAL '1' DAY,'yyyymmdd')<=to_char(start_timestamp,'yyyymmdd') AND
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货