c# 4.0 - creating xml file using c# and oracle -

c# 4.0 - creating xml file using c# and oracle -

i have generate set of xml files querying oracle db table based on condition. xml file construction little complex , limit on file size if limit croees new file need created. best approch this. using select xmlelemnt in oracle plsql or doin in c# after querying info db using cursor? performamce considered , process need done faster.

in plsql cannot manage resulting xml size.

performance-wise, can improve either in plsql or in c#, depends on speed of .net-side machine , speed of oracledb-side machine.

also, if create xml in plqsl , homecoming in caller c# tier, you'll have via clobs. since involve temporary clobs, copying in oracle's temp tablespace might involved, decreasing performance.

all in all, suggest doing rather in c#.

c#-4.0 oracle11g