XML to CLOB taking too much of time
-------------------------------------------------------------------------------------------------------------------------------------------
INSERT /*+ APPEND */ INTO TMP_CONNECTION_ACCOUNTS SELECT :B1 , MPCA.CONNECTION_ID_V , MPCA.ACCOUNT_ID_N , XMLTYPE('<connection-specific><connection value="0"></connection></connection-specific>'). APPENDCHILDXML('/connection-specific/connection',TDFI.FF_XML_X). APPENDCHILDXML('/connection-specific/connection',TDGP.GROUP_XML_X). APPENDCHILDXML('/connection-specific/connection',TDHM.HOMEZONE_XML_X). APPENDCHILDXML('/connection-specific/connection',TDLG.LANGUAGE_XML_X). APPENDCHILDXML('/connection-specific/connection',TDWB.WBLIST_XML_X). APPENDCHILDXML('/connection-specific/connection',TDSM.SEMI_AUTO_XML_X). GETCLOBVAL() FROM TMP_DERIVED_FF_INFO TDFI, TMP_DERIVED_GROUP_INFO TDGP, TMP_DERIVED_HOMEZONE_INFO TDHM , TMP_DERIVED_LANG_INFO TDLG, TMP_DERIVED_WBLIST_INFO TDWB , TMP_DERIVED_SEMIAUTO_INFO TDSM, CONNECTION_ACCOUNT_MAP MPCA