1 Reply Latest reply: May 1, 2008 12:23 PM by Jason_(A_Non) RSS

    DBMS_XMLStore => LPX-00222: error received from SAX callback function

    635498
      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. Re: DBMS_XMLStore cannot handle blank elements !! How to get around ?

      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>