Convert XML to UDT in Oracle
Posted
by Josh
on Stack Overflow
See other posts from Stack Overflow
or by Josh
Published on 2010-03-11T16:03:15Z
Indexed on
2010/03/12
2:57 UTC
Read the original article
Hit count: 245
Filed under:
Oracle
Is there an easy way to convert an XMLType to a User Defined Type? I can convert the UDT to XMLType using the below.
select SYS_XMLGEN(pUDT) into param2 from dual;
I can't though, is find a function that takes that and turns it back into that UDT using the same mappings the SYS_XMLGEN used.
© Stack Overflow or respective owner
