1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| -create table tab1(id number, data clob)
-dbms_xmlschema.registerSchema('http:/toto.xsd', '<..doc xsd..>')
-create table tab2(id number, data xmltype)
XMLType COLUMN XML_DATA
STORE AS OBJECT RELATIONAL
XMLSCHEMA "http:/toto.xsd"
ELEMENT "data"
-create procedure convClobToXmlType(id number)
is
begin
INSERT INTO tab2(ID, DATA);
SELECT ID, XmlType(DATA) FROM tab1 WHERE XML_ID=id);
end;
-create procedure traitementXml(id number)
is
begin
Inser into toto
Select extractvalue(...) field1, extractvalue(...) field2, ...
From tab2 c,
TABLE(XMLSequence(c.DATA.extract(''/data/...''));
...
end; |
Partager