为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8.1
【操作系统】:麒麟10
【CPU】:
【问题描述】*:
达梦当前用户创建的表在存储过程里面报错没有执行对象权限,单独可以执行
CREATE OR REPLACE PROCEDURE P_DWD_GZ_TABLE(FSTARDATE IN VARCHAR(20),FENDDATE IN VARCHAR(20))
AS
V_STARDATE DATE;
V_ENDDATE DATE;
BEGIN
V_STARDATE := TO_DATE(FSTARDATE,'YYYYMMDD');
V_ENDDATE := TO_DATE(FENDDATE,'YYYYMMDD');
--????????
DELETE FROM DWD_CB_BOOKINGRECORD WHERE INDATE>=V_STARDATE AND INDATE<=V_ENDDATE;
INSERT INTO DWD_CB_BOOKINGRECORD
WITH P AS (
SELECT
INDATE,
MAX(INTIME) AS INTIME
FROM ODS.ODS_CB_BOOKINGRECORD
WHERE INDATE>=V_STARDATE AND INDATE<=V_ENDDATE
GROUP BY INDATE
)
SELECT * FROM ODS.ODS_CB_BOOKINGRECORD A
INNER JOIN P ON A.INTIME=P.INTIME;
COMMIT;
END;
是点到执行号了吗?