|
SQL>
SQL> column pf_owner format a10
SQL> column package format a10
SQL> column function format a10
SQL> select pf_owner, package, function
2 from user_policies a
3 where exists ( select null
4 from all_objects
5 where owner = pf_owner
6 and object_type in ( 'FUNCTION', 'PACKAGE',
7 'PACKAGE BODY' )
8 and status = 'INVALID'
9 and object_name in ( a.package, a.function )
10 )
11 /
no rows selected
SQL>
SQL>
|