Hi
We are using
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning and Data Mining options but in the process of upgrading which might take few months.
Server: hp AlphaServer ES80 7/1150
If you require any further information, please let me know. Thank you for your help in advance
I am trying register some XSD's in Oracle. The script:
/**************************************************************
* Trying to register in this order
URN-ENTSOE-EU-LOCAL-EXTENSION-TYPES.XSD;1
URN-ENTSOE-EU-WGEDI-CODELISTS.XSD;
IEC62325-451-N-EICCODE_V1_0.XSD;1
IEC62325-451-3-CAPACITY_V8_0.XSD;1
IEC62325-451-2-SCHEDULE_V5_0.XSD;1
IEC62325-451-1-ACKNOWLEDGEMENT_V8_0.XSD;1
*****************************************************************/
PROMPT Registering XML Schema urn-entsoe-eu-local-extension-types.xsd
BEGIN
DBMS_XMLSCHEMA.registerSchema(
SCHEMAURL => 'urn-entsoe-eu-local-extension-types.xsd',
SCHEMADOC => bfilename('XMLDIR','URN-ENTSOE-EU-LOCAL-EXTENSION-TYPES.XSD'),
LOCAL => TRUE,
GENTYPES => TRUE,
GENBEAN => FALSE,
GENTABLES => TRUE,
FORCE => FALSE,
CSID => 0);
END;
/
--- SUCCESS
PROMPT Registering XML schema urn-entsoe-eu-wgedi-codelists.xsd
BEGIN
DBMS_XMLSCHEMA.registerSchema(
SCHEMAURL => 'urn-entsoe-eu-wgedi-codelists.xsd',
SCHEMADOC => bfilename('XMLDIR','URN-ENTSOE-EU-WGEDI-CODELISTS.XSD'),
LOCAL => TRUE,
GENTYPES => TRUE,
GENBEAN => FALSE,
GENTABLES => TRUE,
FORCE => FALSE,
CSID => 0);
END;
/
--- SUCCESS
PROMPT Registering XML schema iec62325-451-n-eiccode_v1_0.xsd
BEGIN
DBMS_XMLSCHEMA.registerSchema(
SCHEMAURL => 'iec62325-451-n-eiccode\_v1\_0.xsd',
SCHEMADOC => bfilename('XMLDIR','IEC62325-451-N-EICCODE\_V1\_0.XSD'),
LOCAL => TRUE,
GENTYPES => TRUE,
GENBEAN => FALSE,
GENTABLES => TRUE,
FORCE => FALSE,
CSID => 0);
END;
/
--- SUCCESS
PROMPT Registering XML schema iec62325-451-3-capacity_v8_0.xsd
BEGIN
DBMS_XMLSCHEMA.registerSchema(
SCHEMAURL => 'iec62325-451-3-capacity\_v8\_0.xsd',
SCHEMADOC => bfilename('XMLDIR','IEC62325-451-3-CAPACITY\_V8\_0.XSD'),
LOCAL => TRUE,
GENTYPES => TRUE,
GENBEAN => FALSE,
GENTABLES => TRUE,
FORCE => FALSE,
CSID => 0);
END;
/
--FAILURE
PROMPT Registering XML schema iec62325-451-2-schedule_v5_0.xsd
BEGIN
DBMS_XMLSCHEMA.registerSchema(
SCHEMAURL => 'iec62325-451-2-schedule\_v5\_0.xsd',
SCHEMADOC => bfilename('XMLDIR','IEC62325-451-2-SCHEDULE\_V5\_0.XSD'),
LOCAL => TRUE,
GENTYPES => TRUE,
GENBEAN => FALSE,
GENTABLES => TRUE,
FORCE => FALSE,
CSID => 0);
END;
/
--- FAILURE
PROMPT Registering XML schema iec62325-451-1-acknowledgement_v8_0.xsd
BEGIN
DBMS_XMLSCHEMA.registerSchema(
SCHEMAURL => 'iec62325-451-1-acknowledgement\_v8\_0.xsd',
SCHEMADOC => bfilename('XMLDIR','IEC62325-451-1-ACKNOWLEDGEMENT\_V8\_0.XSD'),
LOCAL => TRUE,
GENTYPES => TRUE,
GENBEAN => FALSE,
GENTABLES => TRUE,
FORCE => FALSE,
CSID => 0);
END;
/
-- FAILURE
Summary: The first 3 registration is successful, but later three fails. Error Message:
SQL> PROMPT Registering XML schema iec62325-451-3-capacity_v8_0.xsd
Registering XML schema iec62325-451-3-capacity_v8_0.xsd
SQL> BEGIN
2 DBMS_XMLSCHEMA.registerSchema(
3 SCHEMAURL => 'iec62325-451-3-capacity_v8_0.xsd',
4 SCHEMADOC => bfilename('XMLDIR','IEC62325-451-3-CAPACITY_V8_0.XSD'),
5 LOCAL => TRUE,
6 GENTYPES => TRUE,
7 GENBEAN => FALSE,
8 GENTABLES => TRUE,
9 FORCE => FALSE,
10 CSID => 0);
11 END;
12 /
BEGIN
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17147], [0x080BE0E44], [], [], [],
[], [], []
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 31
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 63
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 152
ORA-06512: at line 2
The .xsd's reference here can be found at this location:
https://www.entsoe.eu/publications/electronic-data-interchange-edi-library/Pages/default.aspx
