PL/SQL
    [ Il "Quarto" fuso ] [ The 4th Time Zone ]   

Why that name?
vForth 1.0
Spectra Forth Tutorial
Download
PL/SQL
The Author

Recompilation of invalid objects 

Here is a puzzle! How to validate objects invalidated for any reason, taking any dipendency between database-objects into account. I developed a script you can download that solves this problem definitively.

It's about a PL/SQL block that examines the result of the following query:

select O.owner, O.object_type, O.object_name, 
       D.referenced_owner, D.referenced_type, D.referenced_name,
       O2.status
from all_dependencies D
   , all_objects O
   , all_objects O2
where O.status = 'INVALID'
  and D.owner (+) = O.owner
  and D.type (+) = O.object_type
  and D.name (+) = O.object_name 
  and D.referenced_owner = O2.owner (+)
  and D.referenced_type = O2.object_type (+)
  and D.referenced_name = O2.object_name (+) 
  and O.owner = USER
order by O.timestamp

building a temporary tables that lists all invalid objects and respective dependencies; subsequently that list is accessed so that the objects will be compiled in the correct order: it's a recursive procedure that before recompile an objects verifies that any dependent object is valid, enentually calling itself with argument such an object...

Ultimo aggiornamento: 10-12-2002. Copyright (c) 2000-2002 Matteo Vitturi. 
Per problemi o domande relativamente a questo sito contattare il webmaster. 
Last update: 12.10.2002. Copyright (c) 2000-2002 Matteo Vitturi.
For problems or questions related to this web please contact the webmaster.