Loading Dependent XSDs in Oracle through Python

Posted by in Software

One essential feature is that schemas can refer to other schemas. Oracle supports it via the schemaURL parameter. In other words, the url of the referred schema must be the same as the schemaURL parameter used to register the referred schema.

One consequence of this feature is the necessity to provide a load order of schemas. In my case, The order would look like this:

The loader segment would be something similar to:

This is all trivial, except the INSERT_STR. A simple sample would be:

Note: Please refer to the previous article to see e.g. connection setup via cx_oracle.

A little experiment: If you find this post and ad below useful, please check the ad out :-)