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
sunal
Messages: 2
Registered: October 2006
Junior Member
Hi

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.

Thanks
Sunal



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

http://forums.oracle.com/forums/thread.jspa?threadID=314755

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 Dec 08 18:41:35 CST 2016

Total time taken to generate the page: 0.05677 seconds