This content has been marked as final. Show 3 replies
Is your question how to send the contents through something like a htp.p('<xml>') or do you have specific parameter and envelope requirements?
It seems like you have the XML bit down.
It can be setup as a page process and you can call the URL (page) with whatever type of prameters and pre-requisites to secure the package that you would like.
Do you mean something similar to this:
I put that code in PL/SQL Region and in a process After Header, but I got errors. I have been trying to accomplish this for more than one week... Can you please set it up for me ?
htp.p('select XMLSERIALIZE (DOCUMENT xmlelement( "LISTINGS", xmlagg( xmlelement( "LISTING", xmlforest( ''RS-''||R."RES_ID" as "Property_Ref_No", R."RES_SIZE" as "Unit_Builtup_Area", R.BEDS as "Bedrooms", R.bath as "No_of_Bathrooms", R.VIDEO as "Web_Tour", ''04473572'' as "Company_Number", ( select xmlagg( xmlelement( "IMAGES", xmlforest( ''http://thevillaproject.com/apex/erp/IMAGES/''||IMG.ID as "link"))) from fateh.images img where (IMG.RES_ID = R.RES_ID) ) IMAGE ))))) x from fateh.res R where res_id < 100')
Thanks in advance,