Skip to Content
0
Former Member
Jul 05, 2007 at 11:47 AM

using sql function in xml sql statement

36 Views

Hello,

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.