I have following statement:
select field1, field2,....,field10 from table( cast (get_mhdata(:1,:2) as mhdata))
where mhdata is an oracle type with 10 fields.
It works good, but I don't know how can I use this statement in xml sql statement.
Please, can you tell me if it is really possible.
Thanks in regards.