Just one note: dbms_xmlgen.getXMLtype truncates "LONG" columns to 4000 bytes, although it works fine with clob -- Best regards, Sayan Malakshinov Senior performance tuning engineer PSBank http://orasql.org -- //www.freelists.org/webpage/oracle-l