ORA-00972: "Identifier is too long" when loading XML-data into table
YkspistoFeb 13 2008 — edited Feb 26 2008Hi,
I downloaded an Expert "Create Components from XSD/WSDL" from here OTN to load XML-data in db-table. I made a simple mapping. It deploys ok, but crashes ORA-00972 in running.
I cut INSERT-clause from the code and tested it in SQL*Developer. It goes ok in Explain Plan, but execute hits also 972-error.
Here is the code:
INSERT
/*+ APPEND PARALLEL("STG_HUOLTOSUHDE_XML") */
INTO
"XML_DATA_OWNER"."STG_HUOLTOSUHDE_XML"
("LAJI")
(SELECT
SUBSTR((extractValue(extract(value(IT_HUOLTOSUHDE),'/HUOLTOSUHDE/LAJI'),'/LAJI')/* EX_HUOLTOSUHDE.OUTGRP1.ALAJI */),"ASI_XML_TEST_MAP"."GET_CONSTANT_5_N1","ASI_XML_TEST_MAP"."GET_CONSTANT_6_N10") "ALAJI"
FROM
DUAL CONSTANT
,
TABLE ((XMLSEQUENCE(EXTRACT((XMLTYPE(bfilename( "ASI_XML_TEST_MAP".GET_CONSTANT_1_DIR_NAME , "ASI_XML_TEST_MAP".GET_CONSTANT_0_FILE_NAME ), nls_charset_id( "ASI_XML_TEST_MAP".GET_CONSTANT_3_NLCHARSET ))/* EXPRESSION.OUTGRP1.XML_OBJECT */), "ASI_XML_TEST_MAP".GET_CONSTANT_4_XPATH_START||''))/* XS_HUOLTOSUHDE.OUTGRP1.XML_OBJECT */)) IT_HUOLTOSUHDE
);
.
.
I'm afraid the problem is after TABLE. Identifier seems very loooong.
Ideas? Workarouds?
Cheers,
Seppo