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.