LISTING 5: Reimplement procedure b as packaged procedure
SQL> create or replace package body pkg_b
2 as
3 procedure b
4 is
5 begin
6 null;
7 end;
8 end;
9 /
Package body created.
SQL> select object_type, object_name, status
2 from user_objects
3 where status = 'INVALID'
4 order by object_type, object_name
5 /
OBJECT_TYPE OBJECT_NAME STATUS
------------ -------------------- ----------------
PROCEDURE A INVALID
|