How to recompile invalid objects recursively

About recompiling invalid objects in Oracle database on the Internet, there is certainly lots of scripts. Still, I decided to write my own package, which can skip recompiling addition of objects, which are undesirable in that moment, or compile them for a long time “hangs” (I mean for example, objects that contain links to remote…

Validating XML with XMLSchema in Oracle database

If you want to use the validation of XML documents using XML Schema in Oracle 9i (or higher), you must first determine if your database supports this option. If the database contains this library you will find the following manner: [Česká verze článku – Validace XML pomocí XMLSchema] My test version of the Oracle 9i…