Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XML Validation: Declaration not found for element Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 10:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 1:55 PM
Points: 1, Visits: 3
I am working with SQL Server 2008 and I am having issues with inserting xml data to a table.the error is:
Msg 6913, Level 16, State 1, Line 17
XML Validation: Declaration not found for element 'items'. Location: /*:items[1]

here is the query:
-- Create a sample database in which to load the XML schema collection.
CREATE DATABASE SampleDB
GO
USE SampleDB
GO

CREATE XML SCHEMA COLLECTION ManuInstructionsSchemaCollection AS
N'<?xml version="1.0" encoding="UTF-16"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.openehr.org/v1"
targetNamespace="http://schemas.openehr.org/v1" elementFormDefault="qualified" version="v1.0.2"
id="BaseTypes.xsd">
<xs:complexType name="DATA_VALUE" abstract="true">
<xs:sequence/>
</xs:complexType>
<xs:complexType name="DV_BOOLEAN">
<xs:complexContent>
<xs:extension base="DATA_VALUE">
<xs:sequence>
<xs:element name="value" type="xs:boolean"/>
</xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
<xs:complexType name="DV_IDENTIFIER">
<xs:complexContent>
<xs:extension base="DATA_VALUE">
<xs:sequence>
<xs:element name="issuer" type="xs:string"/>
<xs:element name="assigner" type="xs:string"/>
<xs:element name="id" type="xs:string"/>
<xs:element name="type" type="xs:string"/>
</xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
</xs:schema>' ;
GO


-- Use it. Create a typed xml variable. Note collection name specified.
DECLARE @x xml (ManuInstructionsSchemaCollection)
GO
--Or create a typed xml column.
CREATE TABLE T (
i int primary key,
x xml (ManuInstructionsSchemaCollection))
GO
DECLARE @data XML;

-- Element-centered XML
SET @data =
N'<items xmlns:xsi="http://www.w3.org/2001/XMLSchema" xsi:type="ELEMENT" archetype_node_id=" at0000">
<name>
<value>id</value>
</name>
<value xsi:type="DV_IDENTIFIER">
<issuer>An ISSUER</issuer>
<assigner>An Assigner</assigner>
<id>0495557225</id>
<type>National Code</type>
</value>
</items>';

INSERT INTO T
VALUES (1000,@data );
-- Clean up
DROP TABLE T
GO
DROP XML SCHEMA COLLECTION ManuInstructionsSchemaCollection
Go
USE Master
GO
DROP DATABASE SampleDB

Post #1467283
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse