I have a weird package issue dbms_xmlgenin Oracle 10g.
Here is my situation:
Queries using this package usually work as expected, without problems.
i.e:.
SQL> select dbms_xmlgen.getXML('select 1 from dual') from dual;
DBMS_XMLGEN.GETXML('SELECT1FRO
--------------------------------------------------------------------------------
<?xml version="1.0"?>
<ROWSET>
<ROW>
<_x0031_>1</_x0031_>
</ROW>
</ROWSET>
However, yesterday afternoon (requests using the package dbms_xmlgen) they generally stopped working with the following error:
ORA-06544: PL/SQL: internal error, arguments: [pef.c:pefpargs2()], [30], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [pef.c:pefpargs2()]
ORA-06512: at "SYS.DBMS_XMLGEN", line 229
ORA-06512: at "SYS.DBMS_XMLGEN", line 175
Rebooting the Oracle server fixed the problem.
The fact is that we rely on this function for several integration functions that we are going to deploy, and I do not want to have unexpected problems when we are in a working environment.
Any ideas / patches / events on the same issue?
Here's the version of Oracle ( select * from v$version) used:
BANNER
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production