ORA-6502: PL/SQL: numeric or value error  tips Oracle Error Tips by Stephanie F.

A user on Oracle DBA Forums encountered ORA-6502 as related to this SQL:

connected to:
Oracle 9i Enterprise Edition Release 9.2.5.0 - Production
With Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

Here is the detail=======================


SQL> DESC DEBUG_TEMP

Name Null? Type
----------------------------------------- -------- ----------------------------
MSG VARCHAR2(500)

SQL> SELECT OWNER,TABLE_NAME FROM ALL_TABLES WHERE TABLE_NAME='DEBUG_TEMP';

OWNER TABLE_NAME
------------------------------ ------------------------------
LCL DEBUG_TEMP

SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','DEBUG_TEMP','LCL') FROM DUAL;

ERROR:
ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '<' instead of 'n'
ORA-06512: at "SYS.UTL_XML", line 0
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3406
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4259
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

SQL> SPOOL OFF
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','DEBUG_TEMP','LCL') FROM DUAL;
ERROR:
ORA-03113: end-of-file on communication channel


no rows selected
SQL>

==========================================

The replier offered this advice:

Since you are the owner

SQL> set long 20000

SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','DEBUG_TEMP') FROM DUAL

These links were also offered on the forum to help the user resolve ORA-6502:

http://www.dba-oracle.com/art_builder_get_schema_syntax.htm

http://www.dba-oracle.com/oracle_tips_dbms_metadata.htm