Home » SQL & PL/SQL » SQL & PL/SQL » Err LPX-00216
Err LPX-00216 [message #199578] Wed, 25 October 2006 03:03 Go to next message
Messages: 2
Registered: October 2006
Junior Member

When I trying to get a DDL information of a view, I am gettin this error.

ORA-06502: PL/SQL: numeric or value error
LPX-00216: invalid character 0 (0x0)
ORA-06512: at "SYS.UTL_XML", line 0
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4157
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

My query is:

select dbms_metadata.get_ddl('VIEW','VW_NAME) from dual;

Can anybody plz help me out in resolving this error.


Re: Err LPX-00216 [message #199582 is a reply to message #199578] Wed, 25 October 2006 03:20 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member


It is like a Bug.

Google Oracle Metalink A/c

[Updated on: Wed, 25 October 2006 03:23]

Report message to a moderator

Previous Topic: How to take data from two table.
Next Topic: Help required in finding Attribute Name
Goto Forum:

Current Time: Thu Jun 22 17:23:55 CDT 2017

Total time taken to generate the page: 0.10879 seconds