Sunday, August 24, 2008

ORA-31605 returned from LpxXSLResetAllVars in routine kuxslResetParams

Problem Description
SQL> select dbms_metadata.get_ddl('TABLE','A') from dual;
ERROR:
ORA-06502: PL/SQL: numeric or value error
ORA-31605: the following was returned from LpxXSLResetAllVars in routine
kuxslResetParams:
LPX-1: NULL pointer
ORA-06512: at "SYS.UTL_XML", line 246
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7511
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9453
ORA-06512: at "SYS.DBMS_METADATA", line 1919
ORA-06512: at "SYS.DBMS_METADATA", line 2792
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1


no rows selected

Solution of The Problem
Solution is the same as in http://arjudba.blogspot.com/2008/08/ora-39212-installation-error-xsl.html.
After executing dbms_metadata_util.load_stylesheets reconnect to your session.

No comments:

Post a Comment