Failure 9134 Error in function XMLTABLE

Database

Failure 9134 Error in function XMLTABLE

Hi All, I am getting the below error while selecting XML data. Failure 9134 Error in function XMLTABLE: Error translating column value to target datatypeReached LOB Segments threshold limit. SQL: SELECT SRC.DW_SYS_ID, X.* FROM (SELECT RQST_NUM, DW_SYS_ID, ACTVTY_LOG FROM SOURCE_TABLE ) AS SRC, XMLTABLE ( '/ActivityDetails/ActivityDetail' PASSING SRC.ACTVTY_LOG COLUMNS "rqstnum" INTEGER PATH 'rqstnum', "incomplianceComments" VARCHAR(10000) PATH 'incomplianceComments', "comments" VARCHAR(10000)PATH 'comments', "dateTime" VARCHAR(10000) PATH 'dateTime', "gpid" VARCHAR(20) PATH 'gpid', "action" VARCHAR(10) PATH 'action', "incompliance" CHAR(1) PATH 'incompliance' ) AS X ( "RQST_NUM", "PLCY_CMPLNC_CMNT_TXT", "ACTVTY_CMNT_TXT","DATETIME", "GP_ID", "ACTVTY_ACTN_CDV", "PLCY_CMPLNC_FLG") WHERE SRC.RQST_NUM = X.RQST_NUM XML Data: 11215 Oracle membership ETCghfgsUser5557856603 ETCghfgsUser5557856603 ETCghfgsUser5557856603 Wed Sep 07 22:44:53 CDT 2016 Submit 55555603 Y 11215 Rejecting as it is duplicate ETCTestUser55555604 ETCTestUser55555604 ETCTestUser55555604 Wed Sep 07 23:22:48 CDT 2016 Reject 55555604 Y 11215 Oracle membership ETCghfgsUser5557856603 ETCghfgsUser5557856603 ETCghfgsUser5557856603 Thu Sep 08 00:11:01 CDT 2016 Submit 55555603 Y 11215 Approved. September 16th Break/Fix Release Change Information • Audience: Global • Date: September 16, 2016 • Change Record: C185497 • Downtime Required: None ETCTestUser55555604 ETCTestUser55555604 ETCTestUser55555604 Thu Sep 08 00:16:29 CDT 2016 Approve 55555604 Y 11215 Approved. ar outside what any reasonable and right-thinking person would consider the habitable zone of Earth's own sun, the moons of the gas-giant planets lay dormant, locked in impossibly thick crusts of ice. Europa, the second major moon of Jupiter, is one such world. For decades, astronomers assumed the only interesting, active bodies in the outer solar system were the giant planets themselves, with their complex atmospheres, strong magnetic fields and hidden depths. These were phenomena worthy of study. But tiny, frigid Europa? Why bother? Bother because this moon's surface is fantastically smooth, almost entirely lacking craters. That's weird: Most of the old, cold, dead worlds in this solar system are pockmarked with craters, remnants of the Late Heavy Bombardment during the frenetic early days of the system's formation. Look at Earth's own moon. Look at Mercury. Old, scarred faces. Europa, on the other hand? A young, sparkling, fresh face. A face whose ice appears to grind and stress against itself like giant icebergs, a plate tectonic system made of ice. Jason ETCTestUser73452355607 ETCTestUser73452355607 ETCTestUser73452355607 Thu Sep 08 00:22:14 CDT 2016 Approve 73452355607 Y 11215 Approved. Hi Josh, Please verify the data setup by performing a test. Calmost entirely lacking craters. That's weird: Most of the old, cold, dead Regards, xyz From: XYZ, A {F} Sent: Wednesday, September 07, 2016 9:43 AM To: XYZ, A {F} Cc: a,b {F}; Zalewa, Jennifer {F};a, b - Contractor {F};a, b {F}; a, b {F} Subject: RE: TEST GPIDs setup for bvxczbcvzjx Hi Padmaja, UAT data set up is completed. Regards Deepak ETCTestUser55555608 ETCTestUser55555608 ETCTestUser55555608 Thu Sep 08 00:25:26 CDT 2016 Approve 55555608 Y Identified the error is due to the column from XML but not able to find the exact error. Thank you for the help!!