Hi
1. Creating an XML file in DB Server location using UTL_FILE
2. Using XMLELEMENT functions as shown
SELECT XMLAGG
(XMLELEMENT ("LAD",
XMLELEMENT("RT",RT),
XMLELEMENT("VN",VN),
XMLELEMENT("AT",AT),
XMLELEMENT("AN",AN),
XMLELEMENT("NAH",NAH),
XMLELEMENT("RSTAT",RSTAT),
XMLELEMENT("RSTAN",RSTAN),
XMLELEMENT("RSDT",RSDT),
XMLELEMENT("AOD",AOD),
XMLELEMENT("CC",CC),
XMLELEMENT("FA",FA),
XMLELEMENT("AL",AL),
XMLELEMENT("PF",PF),
XMLELEMENT("PA",PA),
XMLELEMENT("CL",CL),
XMLELEMENT("AS","AS"),
XMLELEMENT("BPA",BPA),
XMLELEMENT("BPD",BPD),
XMLELEMENT("OB",OB),
XMLELEMENT("OA",OA),
XMLELEMENT("NOP",NOP),
XMLELEMENT("LPA",LPA),
XMLELEMENT("LPD",LPD),
XMLELEMENT("ACD",ACD),
XMLELEMENT("LID",LID),
XMLELEMENT("LOD",LOD),
XMLELEMENT("WOD",WOD),
XMLELEMENT("WOA",WOA),
XMLELEMENT("CRC",CRC),
XMLELEMENT("ASPS",ASPS),
XMLELEMENT("FMPD",FMPD),
XMLELEMENT("LMPD",LMPD),
XMLELEMENT("PTD",PTD),
XMLELEMENT("AST",AST),
XMLELEMENT("ASA",ASA),
XMLELEMENT("PM",PM),
XMLELEMENT("ATD",ATD),
XMLELEMENT("SA",SA),
XMLELEMENT("PDD",PDD),
XMLELEMENT("COA",COA),
XMLELEMENT ("CONSUMER",
XMLELEMENT("RT",RTT),
XMLELEMENT("VN",VN),
XMLELEMENT("AT",AT),
XMLELEMENT("AN",AN),
XMLELEMENT("AHN",NAH),
XMLELEMENT("RTA",RTA),
XMLELEMENT("IDT",IDT),
XMLELEMENT("IDN",IDN),
XMLELEMENT("IDED",IDED),
XMLELEMENT("SC",SC),
XMLELEMENT("NS",NS),
XMLELEMENT("NF",NF),
XMLELEMENT("NM",NM),
XMLELEMENT("DOB",DOB),
XMLELEMENT("NT",NT),
XMLELEMENT("MS",MS),
XMLELEMENT("OI",OI),
XMLELEMENT("HTN",HTN),
XMLELEMENT("WTN",WTN),
XMLELEMENT("MTN",MTN),
XMLELEMENT("ADT",ADT),
XMLELEMENT("ADSD",ADSD),
XMLELEMENT("ADED",ADEDI),
XMLELEMENT("ADF",ADF),
XMLELEMENT("AD",AD),
XMLELEMENT("PC",PC),
XMLELEMENT("PB",PB),
XMLELEMENT("EMP",EMP),
XMLELEMENT("EA",EA),
XMLELEMENT("ESD",ESD),
XMLELEMENT("EED",EED)
)
)
)
FROM XXPSV_SERV_BENEFIT_XML_DATA
3. The Arabic name when opened from notepad returns Junk(but from internet explorer the Arabic data is shown properly)
Can anyone help me on this
Thanks
Tony Thomas