I tried many ways around to find where this error could come from, to no avail:
<pre>
SQLState: 42000

Message: SR449: XML parser detected an error:
FATAL : XML Schema Declaration <x-virt-cache-xsd--urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2> is not valid at line 3 column 92 of '(value to be placed in column tela_dtest.DBA.contacts of content)'
oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2">
----------------------------------------------------------------------^
</pre>

Here's how I created the table:
<sql>
CREATE TABLE tela_dtest..contacts (
  id INTEGER IDENTITY PRIMARY KEY,
content XMLType WITH SCHEMA ('urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2', 'Contact')
);
</sql>
(no error)

The insert statement:
<sql>
INSERT INTO tela_dtest..contacts(content) VALUES('
<?xml version="1.0" encoding="utf-8"?>
<Contact xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2"> <Name xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2">Mrs Bouquet</Name> <Telephone xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2">0158 1233714</Telephone> <Telefax xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2">0158 1233856</Telefax> <ElectronicMail xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2">bouq...@fpconsortial.co.uk</ElectronicMail>
</Contact>
');
</sql>
(error posted at the beginning of this message)


Any hints on how I could fix that?

Thank you,
ericdes

Reply via email to