在system中使用存储过程操纵不同用户下的表
请教:
CREATE OR REPLACE PACKAGE BODY PG_EXPORTDATA AS
PROCEDURE P_EXPORTDATA
IS
v_endtime date;
v_chrendtime char(14);
BEGIN
v_endtime := ADD_MONTHS(sysdate+1,6);
v_chrendtime :=TO_CHAR(v_endtime,'YYYYMMDDHH24MISS');
/* SU1004 */
INSERT INTO TEST.SU1004 NOLOGGING SELECT * FROM CSPAPQ.SU1004 WHERE DATETIME < v_chrendtime;
DELETE FROM CSPAPQ.SU1004 WHERE DATETIME < v_chrendtime;
END P_EXPORTDATA;
END PG_EXPORTDATA;
我在system下,全限 dba ,在 declare 块中调试可以通过,写在包中的存储过程就抱“表和视图不存在?”如何解决?谢谢!