Require DBMS_XMLGEN package script(Spec and Body)

[PAVB]

It may be a syntax or other issue, I would test package with a simple statement - like:

SQL>
SQL> set pagesize 0
SQL> set linesize 150
SQL> set long 9999999
SQL> set head off
SQL>
SQL> select dbms_xmlgen.getxml('select object_name, object_type from sys.dba_objects where rownum < 6') xml
  2  from dual;
<?xml version="1.0"?>
<ROWSET>
 <ROW>
  <OBJECT_NAME>TAB$</OBJECT_NAME>
  <OBJECT_TYPE>TABLE</OBJECT_TYPE>
 </ROW>
 <ROW>
  <OBJECT_NAME>I_IND1</OBJECT_NAME>
  <OBJECT_TYPE>INDEX</OBJECT_TYPE>
 </ROW>
 <ROW>
  <OBJECT_NAME>I_COBJ#</OBJECT_NAME>
  <OBJECT_TYPE>INDEX</OBJECT_TYPE>
 </ROW>
 <ROW>
  <OBJECT_NAME>USER$</OBJECT_NAME>
  <OBJECT_TYPE>TABLE</OBJECT_TYPE>
 </ROW>
 <ROW>
  <OBJECT_NAME>I_OBJ1</OBJECT_NAME>
  <OBJECT_TYPE>INDEX</OBJECT_TYPE>
 </ROW>
</ROWSET>


SQL>