dbms_metadata.get_ddl question

From: Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net>
Date: Tue, 02 May 2006 15:01:53 GMT
Message-ID: <4jse52dcr6901iqn1431agahcs7b9i58qj@4ax.com>

When I try to run the command I get the following:

SQL> select dbms_metadata.get_ddl ('TABLE','STXL','SAPR3') 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 0
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3722
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4553
ORA-06512: at "SYS.DBMS_METADATA", line 458
ORA-06512: at "SYS.DBMS_METADATA", line 615
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1

no rows selected

I had run initmeta.sql and catmeta.sql beforehand. This is what I am running on HP-UX 11i:

SQL> select * from v$version ;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for HPUX: Version 9.2.0.6.0 - Production NLSRTL Version 9.2.0.6.0 - Production

There are about 12000 hits for the phrase dbms_metadata.get_ddl [Results 1 - 10 of about 11,400 for dbms_metadata.get_ddl. (0.38 seconds] and 39 for LPX-1: NULL pointer, none that I can seem to apply. There is only one

Any suggestions?

Come race with us!
http://www.mgpmrc.org Received on Tue May 02 2006 - 10:01:53 CDT