Scribd Logo
Upload

Welcome to Scribd!

  • 139 views

    Apex Invalids

    Uploaded by

    srinu katams
    The document shows the output from SQL commands run on a database. It lists 10 Oracle objects with status "INVALID" and associated package bodies. An attempt to compile one of the invalid package bodies failed with errors, as it referenced another package body that was also invalid. The document also lists the status of database components, showing that the "APEX" component has status "INVALID".

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Apex Invalids

    Uploaded by

    srinu katams
    139 views4 pages
    The document shows the output from SQL commands run on a database. It lists 10 Oracle objects with status "INVALID" and associated package bodies. An attempt to compile one of the invalid package bodies failed with errors, as it referenced another package body that was also invalid. The document also lists the status of database components, showing that the "APEX" component has status "INVALID".

    Original Description:

    oracle invalid object samples

    Original Title

    APEX_INVALIDS

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document shows the output from SQL commands run on a database. It lists 10 Oracle objects with status "INVALID" and associated package bodies. An attempt to compile one of the invalid package bodies failed with errors, as it referenced another package body that was also invalid. The document also lists the status of database components, showing that the "APEX" component has status "INVALID".

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    139 views4 pages

    Apex Invalids

    Uploaded by

    srinu katams
    The document shows the output from SQL commands run on a database. It lists 10 Oracle objects with status "INVALID" and associated package bodies. An attempt to compile one of the invalid package bodies failed with errors, as it referenced another package body that was also invalid. The document also lists the status of database components, showing that the "APEX" component has status "INVALID".

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 4

    SQL> set lines 200 pages 200

    col owner for a30

    col object_name for a30

    select owner,object_name,object_type from dba_objects where status like 'INVALID';SQL> SQL> SQL>

    OWNER OBJECT_NAME OBJECT_TYPE

    ------------------------------ ------------------------------ -----------------------

    APEX_040200 WWV_FLOW_DML PACKAGE BODY

    APEX_040200 WWV_FLOW_UTILITIES PACKAGE BODY

    APEX_040200 WWV_FLOW_SESSION_STATE PACKAGE BODY

    APEX_040200 WWV_FLOW_META_DATA PACKAGE BODY

    APEX_040200 WWV_FLOW_DISP_PAGE_PLUGS PACKAGE BODY

    APEX_040200 WWV_FLOW_SECURITY PACKAGE BODY

    APEX_040200 WWV_FLOW_COLLECTION PACKAGE BODY

    APEX_040200 WWV_FLOW_ITEM PACKAGE BODY


    APEX_040200 WWV_FLOW_WEB_SERVICES PACKAGE BODY

    APEX_040200 WWV_FLOW_XLIFF PACKAGE BODY

    10 rows selected.

    SQL> alter package APEX_040200.WWV_FLOW_DML compile body;

    Warning: Package Body altered with compilation errors.

    SQL> show error

    Errors for PACKAGE BODY APEX_040200.WWV_FLOW_DML:

    LINE/COL ERROR

    -------- -----------------------------------------------------------------

    0/0 PLS-00907: cannot load library unit APEX_040200.WWV_FLOW_SECURITY

    (referenced by APEX_040200.WWV_FLOW_DYNAMIC_EXEC)

    0/0 PLS-00907: cannot load library unit APEX_040200.WWV_FLOW_SECURITY

    (referenced by APEX_040200.WWV_FLOW_DYNAMIC_EXEC)

    0/0 PLS-00907: cannot load library unit APEX_040200.WWV_FLOW_SECURITY

    (referenced by APEX_040200.WWV_FLOW_DYNAMIC_EXEC)

    0/0 PLS-00907: cannot load library unit APEX_040200.WWV_FLOW_SECURITY

    (referenced by APEX_040200.WWV_FLOW_DYNAMIC_EXEC)

    0/0 PLS-00907: cannot load library unit APEX_040200.WWV_FLOW_SECURITY

    (referenced by APEX_040200.WWV_FLOW_DYNAMIC_EXEC)
    0/0 PLS-00907: cannot load library unit APEX_040200.WWV_FLOW_SECURITY

    (referenced by APEX_040200.WWV_FLOW_DYNAMIC_EXEC)

    0/0 PLS-00907: cannot load library unit APEX_040200.WWV_FLOW_SECURITY

    (referenced by APEX_040200.WWV_FLOW_DYNAMIC_EXEC)

    0/0 PLS-00907: cannot load library unit APEX_040200.WWV_FLOW_SECURITY

    (referenced by APEX_040200.WWV_FLOW_DYNAMIC_EXEC)

    0/0 PLS-00907: cannot load library unit APEX_040200.WWV_FLOW_SECURITY

    (referenced by APEX_040200.WWV_FLOW_DYNAMIC_EXEC)

    553/9 PL/SQL: Statement ignored

    645/21 PL/SQL: Statement ignored

    1116/5 PL/SQL: Statement ignored

    1167/17 PL/SQL: Statement ignored

    1480/9 PL/SQL: Statement ignored

    1491/13 PL/SQL: Statement ignored

    1533/13 PL/SQL: Statement ignored

    1619/9 PL/SQL: Statement ignored

    1626/9 PL/SQL: Statement ignored

    SQL>

    SQL> col comp_id for a30

    SQL> select comp_id,status from dba_registry;

    COMP_ID STATUS

    ------------------------------ --------------------------------------------

    DV VALID

    APEX INVALID
    OLS VALID

    SDO VALID

    ORDIM VALID

    CONTEXT VALID

    OWM VALID

    XDB VALID

    CATALOG VALID

    CATPROC VALID

    JAVAVM VALID

    XML VALID

    CATJAVA VALID

    APS VALID

    XOQ VALID

    RAC OPTION OFF

    16 rows selected.

    SQL>

    You might also like