Oracle 10G R2 and FIXML

, ,
1

Imported from previous forum

2

Hi,

I have been trying to get the schema registered for FIXML in oracle and have run into the following problems:

  1. It appears when registering the schema Oracle it dose not support xs:include. Is this correct or am I doing something wrong?

  2. To get around the issue with xs:include I merged the entire XML schema into one file. I then ran into some issues with the size of the XML schema. How do I go about getting around this?

Thanks in advance,
Rob

P

3

[ original email was from Kevin Houstoun - kevinh@altkb.com ]
Hi

Cannot vouch for Oracle but we’ve seen problems with other tools not supporting the schema as it is.

One approach around the schema size is to generate either a schema for each message you require or a schema for just the messages you require. This approach has been discussed in the past on the FIXML board.

Cheers
Kevin

Hi,

I have been trying to get the schema registered for FIXML in oracle and
have run into the following problems:

  1. It appears when registering the schema Oracle it dose not support
    xs:include. Is this correct or am I doing something wrong?

  2. To get around the issue with xs:include I merged the entire XML
    schema into one file. I then ran into some issues with the size of
    the XML schema. How do I go about getting around this?

Thanks in advance, Rob

P

4
  1. To get around the issue with xs:include I merged the entire XML
    schema into one file. I then ran into some issues with the size of
    the XML schema. How do I go about getting around this?

The schema is too large for a string literal used in the regular way of imprtang an xsd.
To get around this run the following from SQL Plus, changing your xsd/table names as req’d :

CREATE DIRECTORY DOC_DIR AS ‘mypath\xsd\fix\5.0sp2’;
DECLARE
SOURCE_FILE BFILE := BFILENAME(‘DOC_DIR’, ‘fixml-tradecapture-base-5-0-SP2.xsd’);
BEGIN
dbms_xmlschema.registerSchema(
‘fixml-tradecapture-base-5-0-SP2’,
SOURCE_FILE,
TRUE, TRUE, FALSE, FALSE);
END;
/