Check package status : USER_OBJECTS « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. USER_OBJECTS

Check package status

    

SQL>
SQL> create table t ( x int );

Table created.

SQL>
SQL> create or replace view v as select * from t;

View created.

SQL>
SQL> create or replace procedure p
  2  as
  3  begin
  4          for x in ( select * from t )
  5          loop
  6                  null;
  7          end loop;
  8  end;
  9  /


SQL>
SQL> create or replace function f return number
  2  as
  3          countValue number;
  4  begin
  5          select count(*) into countValue from t;
  6          return countValue;
  7  end;
  8  /

Function created.

SQL>
SQL>
SQL> create or replace procedure p2
  2  as
  3  begin
  4          p;
  5  end;
  6  /

SQL>
SQL>
SQL>
SQL>
SQL> create or replace package p1
  2  as
  3          procedure p;
  4  end;
  5  /


SQL>
SQL> create or replace package body p1
  2  as
  3  procedure p
  4  as
  5  begin
  6          for x in ( select * from t )
  7          loop
  8                  null;
  9          end loop;
 10  end;
 11  end p1;
 12  /


SQL>
SQL> create or replace package p2
  2  as
  3          procedure p;
  4  end;
  5  /


SQL>
SQL> create or replace package body p2
  2  as
  3  procedure p
  4  as
  5  begin
  6          p1.p;
  7  end;
  8  end p2;
  9  /


SQL>
SQL> select object_name, object_type, status
  2    from user_objects
  3    where rownum < 10
  4  /

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         STATUS
------------------- -------
MYSTATS
INDEX               VALID

MYSTATS
TABLE               VALID

S
SEQUENCE            VALID


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         STATUS
------------------- -------
P_ADD_ITEMS
PROCEDURE           INVALID

WORKING_CUSTOMERS
TABLE               VALID

ADDTUPLE3
PROCEDURE           INVALID


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         STATUS
------------------- -------
P_ADD_ORDERS
PROCEDURE           INVALID

P_ADD_PROD
PROCEDURE           INVALID

UPDATE_PRODUCT_PRICE
PROCEDURE           INVALID


9 rows selected.

SQL>

   
    
    
    
  

Related examples in the same category