2 Replies Latest reply: Mar 21, 2013 12:15 PM by r.ricardo.r RSS

    Object  does not exist

    r.ricardo.r
      Hi,
      I listed invalid object, but when compilo object, say that not exist.
      Help me please.

      SQL> SELECT OBJECT_NAME, OBJECT_TYPE FROM DBA_OBJECTS WHERE STATUS='INVALID' AND OBJECT_NAME ='PCK_PIR_NFEL_MILLENIUM' AND OWNER='PIRAMIDE'

      OBJECT_NAME OBJECT_TYPE
      --------------------------------- --------------------
      PCK_PIR_NFEL_MILLENIUM PACKAGE

      SQL> ALTER PACKAGE PCK_PIR_NFEL_MILLENIUM COMPILE;
      ALTER PACKAGE PCK_PIR_NFEL_MILLENIUM COMPILE
      *
      ERROR at line 1:
      ORA-04043: object PCK_PIR_NFEL_MILLENIUM does not exist