PL/SQL (MOSC)

MOSC Banner

SQL Statement ignored ORA-00942: table or view does not exist

edited Jul 22, 2015 2:03AM in PL/SQL (MOSC) 2 commentsAnswered ✓

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center