This content has been marked as final. Show 3 replies
SQL> alter trigger sys.xdb_pi_trig compile; SQL> show errors
It compiles with errors.
The output from show errors is:
PL/SQL Statement ignored
PLS-00905: object SYS.IS_VPD_ENABLED is invalid
Is anything that could be done?
Then try compile that function:
SQL>alter function SYS.IS_VPD_ENABLED compile; SQL>show errors
select object_name from dba_objects where status !='VALID' and owner = 'SYS'