PLSQL type file generator from xsd

657 views Asked by At

Is there any API, command or tools available, which generates plsql type file in .sql format( so that i can keep in version control ) which may undergo changes for multiple releases, for the given xsd schema ?. Assumption is PLSQL SP takes and returns XML clob object.

1

There are 1 answers

0
Martina On

There is a procedure DBMS_XMLSCHEMA.REGISTERSCHEMA which based on .xsd ( and when parameter gentypes is set to TRUE) generates also database types.

However I'm afraid, that you have to save the generated DDL of these types just manually after they are generated.