OracleXml putxml limitations
OracleXml putxml limitations:
Example1:xml file(test.xml):
ROWSET
ROW num="2"
ID 15 /ID
/ROW
/ROWSET
(using the java API for XDK) the below command
java OracleXML putXML -user "vidya/vidya" -ignorecase –filename "test.xml" "emp"
will load one row into table emp.
Example2:Xml file with namespaces (test1.xml):
ns:EMP
ns:ITEM
ns:ID 2 /ns:ID
/ns:ITEM
/ns:EMP
(using the java API for XDK) the below command
java OracleXML putXML -user "vidya/vidya" -ignorecase –filename "test1.xml" "emp"
if “OracleXML” cannot identifiy the ROWTAG the above command can be modified as below
java OracleXML putXML -user "vidya/vidya" -ignorecase –rowtag “ITEM” –filename "test1.xml" "emp"
note the above will error as OracleXML doesn’t seem to be working on
a file with namespaces. The only way to probably get around this is by applying a stylesheet.
Example1:xml file(test.xml):
ROWSET
ROW num="2"
ID 15 /ID
/ROW
/ROWSET
(using the java API for XDK) the below command
java OracleXML putXML -user "vidya/vidya" -ignorecase –filename "test.xml" "emp"
will load one row into table emp.
Example2:Xml file with namespaces (test1.xml):
ns:EMP
ns:ITEM
ns:ID 2 /ns:ID
/ns:ITEM
/ns:EMP
(using the java API for XDK) the below command
java OracleXML putXML -user "vidya/vidya" -ignorecase –filename "test1.xml" "emp"
if “OracleXML” cannot identifiy the ROWTAG the above command can be modified as below
java OracleXML putXML -user "vidya/vidya" -ignorecase –rowtag “ITEM” –filename "test1.xml" "emp"
note the above will error as OracleXML doesn’t seem to be working on
a file with namespaces. The only way to probably get around this is by applying a stylesheet.
0 Comments:
Post a Comment
<< Home