If procedure is valid : USER_OBJECTS « System Tables Views « Oracle PL / SQL






If procedure is valid

    
SQL> CREATE TABLE EMP(
  2      EMPNO NUMBER(4) NOT NULL,
  3      ENAME VARCHAR2(10),
  4      JOB VARCHAR2(9),
  5      MGR NUMBER(4),
  6      HIREDATE DATE,
  7      SAL NUMBER(7, 2),
  8      COMM NUMBER(7, 2),
  9      DEPTNO NUMBER(2)
 10  );

Table created.

SQL> create or replace procedure P1 is
  2   v_cnt number;
  3   begin
  4       select count(*) into v_cnt from emp where empno > 0;
  5   end;
  6  /



SQL>
SQL> select object_name, status from user_objects where object_name in ('P1','P2','P3','P4');
Enter...

P1
VALID

P1
INVALID

P2
INVALID

P2
INVALID

P3
INVALID

P4
INVALID


6 rows selected.

SQL>
SQL> select object_name, status from user_objects where object_name in ('P1','P2','P3','P4');
Enter...

P1
VALID

P1
INVALID

P2
INVALID

P2
INVALID

P3
INVALID

P4
INVALID


6 rows selected.

SQL>
SQL> drop table emp;

Table dropped.

   
    
    
    
  








Related examples in the same category

1.Query user_objects table
2.Query USER_OBJECTS table by object name
3.Query object_type, object_name from user_objects
4.Query user_objects table for all procedure
5.list all stored procedures: 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY'
6.Query user_objects in PL/SQL
7.Query a view in user_objects table for a view just created
8.Query user_objects for invalid package body
9.Query user-objects for stored procedure
10.Query user_objects for trigger
11.Query user_objects for invalid view
12.Query all INVALID objects from user_objects table
13.Get code for all procedure, function and package from user_objects
14.Query user_objects table for stored procedure before and after recompile
15.A procedure with dependencies
16.Check package status
17.Check new created tables in user_objects
18.Finding, Validating, and Describing Packages
19.Get object id for created table
20.Show the procedure is marked invalid **
21.Show the status of a procedure
22.To find out what procedures and functions you have created, use the following SQL query: