SQL Statement ignored ORA-00942: table or view does not exist
Hi to all,
we are running an 11.2.0.2.0 Rac Database. We are facing multilpe errors when creating a procedure with user "system" in our preproduction environment:
PROCEDURE LOAD_FULL_TABLE (P_LOAD_DATE DATE, P_TABLE VARCHAR2) IS
CADENA VARCHAR2(300);
CURSOR C1 IS
SELECT OWNER, TABLE_NAME, CONSTRAINT_NAME FROM DBA_CONSTRAINTS WHERE R_owner = 'DTSPREP' and R_CONSTRAINT_NAME IN
(select CONSTRAINT_NAME FROM DBA_CONSTRAINTS WHERE OWNER = 'DTSPREP' AND TABLE_NAME = P_TABLE);
BEGIN
CADENA := '';
BEGIN
INSERT INTO SYSTEM.CTRL_HISTORY_WINDOW (LOADED_DATE, TAB_NAME, BEGIN_DATE, END_DATE)
VALUES (P_LOAD_DATE, P_TABLE, SYSDATE, NULL);