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: Delete even rows of a table
Next Topic: Populating Text File with records from a table
Goto Forum:

Current Time: Sat Aug 19 17:36:41 CDT 2017

Total time taken to generate the page: 0.02275 seconds