SQL & PL/SQL

Hi,

I'm trying to generate XML schema (XSD) based on custom queries (using a number of tables and views). I tried using DBMS_XMLQUERY.getXML() and passing DBMS_XMLQUERY.SCHEMA constant. It generates the XML for resulting recordset along with an Internal Schema. I know that DBMS_XMLQUERY.getDTD() can generate DTDs for a given query context. But unfortunately, I could not find any function or procedure to generate seperate XSD!

There is another choice for generating XSDs, that is using DBMS_XMLSCHEMA.GENERATESCHEMA(). But that only works with ORACLE Types. So, I can't use that.

Can Anyone help?

Cheers,
Arif Rahman