Require DBMS_XMLGEN package script(Spec and Body)

[shivam]

Thanks!

I ran the two scripts and was able to create the package DBMS_XMLGEN.GETXML successfully..

However, was unable to use the function to generate the XML..here's what I did...

SQL I ran to generate XML:
select dbms_xmlgen.getXml('''select dbms_xmlschema.generateschema('''||'HR'||''','''||'TBL_URS'||''')''') from dual;

Here's the error:
ERROR:
ORA-19202: Error occurred in XML processing
ORA-24333: zero iteration count
ORA-06512: at "SYS.DBMS_XMLGEN", line 176
ORA-06512: at line 1