DevOps, CI/CD and Automation

I am trying to load below XML file in a relational table in two steps:

1) Loading the file in a CLOB
2) Calling DBMS_XMLStore.insertXML with required details

But the second step is giving me below error

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00222: error received from SAX callback function
ORA-06512: at "STAGINGDBO.INSERT_XML", line 84
ORA-06512: at line 2

select COMP_ID, VERSION from DBA_REGISTRY
COMP_ID VERSION
------------------------------ ------------------------------
EM 10.2.0.2.0
XDB 10.2.0.2.0
CATALOG 10.2.0.2.0
CATPROC 10.2.0.2.0
JAVAVM 10.2.0.2.0
CATJAVA 10.2.0.2.0
XML 10.2.0.2.0

I tried using the DBMS_XMLSave and it worked fine with this XML. I decided to go for DBMS_XMLStore because it uses SAX and I am expecting 100K records to process in this XML file.

I read somewhere that DBMS_XMLStore do not work if you don't have value specified for all tags but then I got confused after reading below link as it says it worked fine. 1296931

Is there any other issue in this XML file or is there any otherway of processing such large volume file? Please help.

xml_file.xml

<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<security security_count="1" variable_rate_count="0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="security.xsd">
<security_row><security_id>LZ002359750</security_id><primary_asset_id>B2479G9</primary_asset_id><delay_days xsi:nil="true"></delay_days><arm_indicator xsi:nil="true"></arm_indicator><camra_abs_und_coll xsi:nil="true"></camra_abs_und_coll><camra_abs_und_coll_cpn xsi:nil="true"></camra_abs_und_coll_cpn><initial_principal_pay_date xsi:nil="true"></initial_principal_pay_date><final_principal_pay_date xsi:nil="true"></final_principal_pay_date><mtg_term xsi:nil="true"></mtg_term><original_face xsi:nil="true"></original_face><pool_number xsi:nil="true"></pool_number><principal_pay_frequency xsi:nil="true"></principal_pay_frequency><pay_down_date xsi:nil="true"></pay_down_date><principal_pay_bus_day_rule xsi:nil="true"></principal_pay_bus_day_rule><seasoned_mbs xsi:nil="true"></seasoned_mbs><tba_stlmt_month xsi:nil="true"></tba_stlmt_month><accrual_flag>Y</accrual_flag><accrual_rule>1</accrual_rule><base_payment_date>0831</base_payment_date><day_count>ACT/ACT</day_count><ex_interest_bond_code xsi:nil="true"></ex_interest_bond_code><ex_days xsi:nil="true"></ex_days><ex_div_date xsi:nil="true"></ex_div_date><last_coupon_date>2017-08-31</last_coupon_date><for_bond_security_type>GER</for_bond_security_type><dated_date>2007-08-31</dated_date><issue_date>2007-08-31</issue_date><first_coupon_date>2008-08-31</first_coupon_date><second_coupon_date>2009-08-31</second_coupon_date><mat_date>2017-08-31</mat_date><interest_accrual_method>PER</interest_accrual_method><odd_first_coupon_date xsi:nil="true"></odd_first_coupon_date><odd_last_coupon_date xsi:nil="true"></odd_last_coupon_date><payment_eom_rule>Y</payment_eom_rule><pay_frequency>A</pay_frequency><pay_business_day_rule>BD</pay_business_day_rule><yield_day_count>ACT/ACT</yield_day_count><zero_coupon_type xsi:nil="true"></zero_coupon_type><analyst>SH</analyst><analyst_recomm xsi:nil="true"></analyst_recomm><approval_flag>Y</approval_flag><camra_sec_type xsi:nil="true"></camra_sec_type><class xsi:nil="true"></class><comments xsi:nil="true"></comments><holding_style>BE</holding_style><issued_capital xsi:nil="true"></issued_capital><issued_capital_currency>EUR</issued_capital_currency><min_denomination>50000</min_denomination><price_multiplier>0.01</price_multiplier><pricing_identifier xsi:nil="true"></pricing_identifier><quantity_issued>2250000</quantity_issued><shares_outstanding>2250000</shares_outstanding><quantity_type>PAR</quantity_type><redemption_value>100</redemption_value><scb_industry xsi:nil="true"></scb_industry><issue_desc1>DEUTSCHE BANK AG</issue_desc1><issue_desc2 xsi:nil="true"></issue_desc2><issue_desc3 xsi:nil="true"></issue_desc3><issue_short_name>DEUTSCHE BANK AG</issue_short_name><trading_lot_size>50000</trading_lot_size><unit_factor>1</unit_factor><camra_exercise_date xsi:nil="true"></camra_exercise_date><camra_expiration_date xsi:nil="true"></camra_expiration_date><alliance_sector>230</alliance_sector><alliance_industry>23030</alliance_industry><camra_gl_type xsi:nil="true"></camra_gl_type><emerg_mkt_ind xsi:nil="true"></emerg_mkt_ind><form_13f_flag xsi:nil="true"></form_13f_flag><instrument_class>FI</instrument_class><issue_type>BOND</issue_type><mortgage_sector>ZZ</mortgage_sector><naic_code xsi:nil="true"></naic_code><performance_segment>3</performance_segment><program_type xsi:nil="true"></program_type><camra_sic_code2 xsi:nil="true"></camra_sic_code2><camra_sched_d_group xsi:nil="true"></camra_sched_d_group><camra_sched_d_state xsi:nil="true"></camra_sched_d_state><security_form xsi:nil="true"></security_form><security_type_distrib xsi:nil="true"></security_type_distrib><camra_sic_code xsi:nil="true"></camra_sic_code><structured_note_flag>N</structured_note_flag><underlying_category xsi:nil="true"></underlying_category><primary_asset_id_type>aPACE</primary_asset_id_type><superticker>B2479G9</superticker><default_status>N</default_status><default_date xsi:nil="true"></default_date><accrue_in_default_ind>N</accrue_in_default_ind><ctd_bond xsi:nil="true"></ctd_bond><contract_size xsi:nil="true"></contract_size><derivative_type xsi:nil="true"></derivative_type><delivery_method xsi:nil="true"></delivery_method><conversion_factor xsi:nil="true"></conversion_factor><flex_option_ind xsi:nil="true"></flex_option_ind><leap_option_ind xsi:nil="true"></leap_option_ind><orig_strike_price xsi:nil="true"></orig_strike_price><otc_flag xsi:nil="true"></otc_flag><part_paid_percent xsi:nil="true"></part_paid_percent><strike_price xsi:nil="true"></strike_price><put_call_flag xsi:nil="true"></put_call_flag><strike_price_type xsi:nil="true"></strike_price_type><pay_currency xsi:nil="true"></pay_currency><rec_currency xsi:nil="true"></rec_currency><premium_amount xsi:nil="true"></premium_amount><warrant_style xsi:nil="true"></warrant_style><pay_status xsi:nil="true"></pay_status><tick_amount xsi:nil="true"></tick_amount><right_warrant_option_type xsi:nil="true"></right_warrant_option_type><underlying_cusip xsi:nil="true"></underlying_cusip><var_margin_rule xsi:nil="true"></var_margin_rule><nominal_annual_income xsi:nil="true"></nominal_annual_income><dividend_frequency xsi:nil="true"></dividend_frequency><dividend_reinvestment_ind xsi:nil="true"></dividend_reinvestment_ind><dr_sponsoring xsi:nil="true"></dr_sponsoring><dr_sponsor xsi:nil="true"></dr_sponsor><claim_type>UNSUB</claim_type><dated_date_cpi xsi:nil="true"></dated_date_cpi><when_issued_ind xsi:nil="true"></when_issued_ind><series>EMTN</series><tranche xsi:nil="true"></tranche><guarantee_type xsi:nil="true"></guarantee_type><deep_discount_ind>N</deep_discount_ind><perpetual_flag>N</perpetual_flag><maturity_override>N</maturity_override><camra_index_desc xsi:nil="true"></camra_index_desc><camra_index_spread xsi:nil="true"></camra_index_spread><coupon>5.125</coupon><rate_benchmark xsi:nil="true"></rate_benchmark><rate_multiplier xsi:nil="true"></rate_multiplier><spread_to_benchmark xsi:nil="true"></spread_to_benchmark><rate_reset_frequency xsi:nil="true"></rate_reset_frequency><rate_base_reset_date xsi:nil="true"></rate_base_reset_date><reset_lag_days xsi:nil="true"></reset_lag_days><reset_lockout_days xsi:nil="true"></reset_lockout_days><next_reset_date xsi:nil="true"></next_reset_date><rate_calculate_switch>N</rate_calculate_switch><rate_reset_bus_day_rule xsi:nil="true"></rate_reset_bus_day_rule><rate_reset_eom_rule xsi:nil="true"></rate_reset_eom_rule><rate_type>FIX</rate_type><mutual_fund_sponsor xsi:nil="true"></mutual_fund_sponsor><regulated_flag xsi:nil="true"></regulated_flag><tia_1961_flag xsi:nil="true"></tia_1961_flag><accumulation_income_flag xsi:nil="true"></accumulation_income_flag><fsa_indicator xsi:nil="true"></fsa_indicator><income_dist_policy xsi:nil="true"></income_dist_policy><mutual_fund_charge_type xsi:nil="true"></mutual_fund_charge_type><holdings_flag xsi:nil="true"></holdings_flag><issuer_type>C</issuer_type><issuer_id>006417</issuer_id><parent_issuer_id>006417</parent_issuer_id><country>EU</country><currency>EUR</currency><country_of_origin>DE</country_of_origin><risk_country>DE</risk_country><currency_of_earnings>EUR</currency_of_earnings><currency_of_income>EUR</currency_of_income><currency_of_trade>EUR</currency_of_trade><principal_currency>EUR</principal_currency><exchange>OTC</exchange><state_code xsi:nil="true"></state_code><muni_insurance xsi:nil="true"></muni_insurance><conduit xsi:nil="true"></conduit><muni_note_type xsi:nil="true"></muni_note_type><muni_issuer xsi:nil="true"></muni_issuer><obligation_type xsi:nil="true"></obligation_type><oes_next_call_date xsi:nil="true"></oes_next_call_date><offering_yield xsi:nil="true"></offering_yield><remarketing_agent xsi:nil="true"></remarketing_agent><tax_exempt_region xsi:nil="true"></tax_exempt_region><fed_wire>N</fed_wire><oid_flag>N</oid_flag><oid_number xsi:nil="true"></oid_number><oi_price xsi:nil="true"></oi_price><camra_moody_sector xsi:nil="true"></camra_moody_sector><restricted>N</restricted><camra_class_144>N</camra_class_144><foreign_restriction_ind xsi:nil="true"></foreign_restriction_ind><foreign_restriction_req xsi:nil="true"></foreign_restriction_req><sec_144a>N</sec_144a><reg_s>N</reg_s><prvt_place_ind>N</prvt_place_ind><liquid_flag>N</liquid_flag><call_protection_period xsi:nil="true"></call_protection_period><call_protection_type xsi:nil="true"></call_protection_type><camra_make_whole_ind>N</camra_make_whole_ind><camra_conversion_price xsi:nil="true"></camra_conversion_price><convertible_flag>N</convertible_flag><nra_tax_code>N</nra_tax_code><tax_relief_at_source_ind>N</tax_relief_at_source_ind><tax_withholding_code>N</tax_withholding_code><tax_status>FS</tax_status><voting_rights xsi:nil="true"></voting_rights><votes_per_share xsi:nil="true"></votes_per_share><csum_voting_flag xsi:nil="true"></csum_voting_flag><coupon_cap xsi:nil="true"></coupon_cap><coupon_floor xsi:nil="true"></coupon_floor><cross_currency_country xsi:nil="true"></cross_currency_country><cross_currency_fwd_rate xsi:nil="true"></cross_currency_fwd_rate><cross_rate xsi:nil="true"></cross_rate><fwd_base_rate xsi:nil="true"></fwd_base_rate><fwd_rate xsi:nil="true"></fwd_rate><fwd_reset_date xsi:nil="true"></fwd_reset_date><spot_base_rate xsi:nil="true"></spot_base_rate><spot_cross_rate xsi:nil="true"></spot_cross_rate><fwd_point_difference xsi:nil="true"></fwd_point_difference><fwd_broker_code xsi:nil="true"></fwd_broker_code><fwd_side xsi:nil="true"></fwd_side><redemption_currency xsi:nil="true"></redemption_currency><redenomination_date>2007-08-31</redenomination_date><redenomination_flag>Y</redenomination_flag><amt_flag>NULL</amt_flag><capital_income_flag>C</capital_income_flag><cfb_level_pay xsi:nil="true"></cfb_level_pay><fido_flag>N</fido_flag><pending_corp_action>N</pending_corp_action><pending_proxy_vote>N</pending_proxy_vote><pms_live_indicator>Y</pms_live_indicator><pms_price_type>A</pms_price_type><spark_flag>N</spark_flag><whittingdale_debt_cat xsi:nil="true"></whittingdale_debt_cat><whittingdale_rating xsi:nil="true"></whittingdale_rating><whittingdale_issuer xsi:nil="true"></whittingdale_issuer><whittingdale_code xsi:nil="true"></whittingdale_code><expiration_date xsi:nil="true"></expiration_date><maturity_price xsi:nil="true"></maturity_price><commencement_date xsi:nil="true"></commencement_date><declared_payment_date xsi:nil="true"></declared_payment_date><drawer xsi:nil="true"></drawer><fv_volatility xsi:nil="true"></fv_volatility><mv_volatility xsi:nil="true"></mv_volatility><settle_period xsi:nil="true"></settle_period><trading_margin xsi:nil="true"></trading_margin><compound_frequency xsi:nil="true"></compound_frequency><coupon_rounding xsi:nil="true"></coupon_rounding><duration_to_reset>N</duration_to_reset><float_rate_index_location xsi:nil="true"></float_rate_index_location><periodic_basis_point_cap xsi:nil="true"></periodic_basis_point_cap><settlement_location xsi:nil="true"></settlement_location><attachment_lower xsi:nil="true"></attachment_lower><attachment_upper xsi:nil="true"></attachment_upper><exposure_type xsi:nil="true"></exposure_type><nth2default xsi:nil="true"></nth2default><restruct_doc_clause xsi:nil="true"></restruct_doc_clause><swap_counterparty xsi:nil="true"></swap_counterparty><swaption_issue_date xsi:nil="true"></swaption_issue_date><swaption_mat_date xsi:nil="true"></swaption_mat_date><make_whole_call_flag>N</make_whole_call_flag><orig_entrydate>2007-08-31T06:01:52</orig_entrydate><orig_enteredby>edeben</orig_enteredby><last_entrydate>2007-08-31T06:01:52</last_entrydate><last_enteredby>edeben</last_enteredby><apace_security_type>0230</apace_security_type><credit_family_id>006417</credit_family_id><cusip xsi:nil="true"></cusip><isin>DE000DB5S5U8</isin><sedol>B2479G9</sedol><ticker xsi:nil="true"></ticker><wal_date xsi:nil="true"></wal_date><weighted_average_coupon xsi:nil="true"></weighted_average_coupon><apace_call_price xsi:nil="true"></apace_call_price><apace_call_date xsi:nil="true"></apace_call_date><apace_callable_flag>N</apace_callable_flag><apace_put_price xsi:nil="true"></apace_put_price><apace_put_date xsi:nil="true"></apace_put_date><apace_putable_flag>N</apace_putable_flag><apace_accrual_type>PER</apace_accrual_type><apace_day_count>ACT/ACT</apace_day_count><apace_io_ind>N</apace_io_ind><apace_pass_thru_flag>N</apace_pass_thru_flag><apace_price_method>Q</apace_price_method><apace_price_source>X</apace_price_source><apace_depository_type xsi:nil="true"></apace_depository_type><apace_conv_ratio xsi:nil="true"></apace_conv_ratio><apace_floating_rate>N</apace_floating_rate><apace_frn_reset_code xsi:nil="true"></apace_frn_reset_code><apace_frn_reset_date xsi:nil="true"></apace_frn_reset_date><apace_step_conversion_date xsi:nil="true"></apace_step_conversion_date><apace_step_conversion_rate xsi:nil="true"></apace_step_conversion_rate><apace_accrual_date_code xsi:nil="true"></apace_accrual_date_code><apace_payment_date_code xsi:nil="true"></apace_payment_date_code><apace_payment_cycle_code xsi:nil="true"></apace_payment_cycle_code><apace_par_call_date xsi:nil="true"></apace_par_call_date><apace_prerefund_price xsi:nil="true"></apace_prerefund_price><apace_prerefund_date xsi:nil="true"></apace_prerefund_date><apace_sink_fund_flag>N</apace_sink_fund_flag><fido_security_type_jvst xsi:nil="true"></fido_security_type_jvst><fido_security_type_jstp xsi:nil="true"></fido_security_type_jstp><fido_issuer_id xsi:nil="true"></fido_issuer_id><fido_guarantor_id xsi:nil="true"></fido_guarantor_id><fido_name xsi:nil="true"></fido_name><draft_id xsi:nil="true"></draft_id><bbsw_at_last_reset xsi:nil="true"></bbsw_at_last_reset><delta xsi:nil="true"></delta><price>100.8675</price><benchmark_index_sec xsi:nil="true"></benchmark_index_sec><index_multiplier xsi:nil="true"></index_multiplier><index_spread xsi:nil="true"></index_spread><index_link_location xsi:nil="true"></index_link_location><index_lag xsi:nil="true"></index_lag><benchmark_rounding xsi:nil="true"></benchmark_rounding><index_link_bus_day_rule xsi:nil="true"></index_link_bus_day_rule><calculation_type xsi:nil="true"></calculation_type><start_day_of_month xsi:nil="true"></start_day_of_month><pms_issue>DEUTSCHE BANK AG</pms_issue><pms_name>08/31/2017</pms_name><camra_cusip>EG7882376</camra_cusip><infoexpress_id xsi:nil="true"></infoexpress_id><issuer_desc>DEUTSCHE BANK AG</issuer_desc><parent_issuer_desc>DEUTSCHE BANK AG</parent_issuer_desc><lead_mgr xsi:nil="true"></lead_mgr><co_mgr xsi:nil="true"></co_mgr><superticker_desc xsi:nil="true"></superticker_desc><fmc_id>B2479G X</fmc_id><spintl_id xsi:nil="true"></spintl_id><tranche_type xsi:nil="true"></tranche_type><collateral_type xsi:nil="true"></collateral_type><ab_fund_desc xsi:nil="true"></ab_fund_desc><adp_number xsi:nil="true"></adp_number><underlying_account_id xsi:nil="true"></underlying_account_id></security_row>
</security>