oracle xmltype 不支持的 Oracle 数据类型 USERDEFINED
1
SELECT DOC_ID, EXTRACTValue(XML_DATA, '/Experiment/Parameters/Parameter[@col="H" and @row="试验1"]')
2 FROM EXPERIMENTS
3 WHERE EXISTSNODE(XML_DATA, '/Experiment/Parameters/Parameter[@col="H" and @row="试验1"]') = 1
如上面的 sql 语句 查询xmltype类型字段时在pl/slq里面执行显示很好SELECT DOC_ID, EXTRACTValue(XML_DATA, '/Experiment/Parameters/Parameter[@col="H" and @row="试验1"]') 2
FROM EXPERIMENTS 3
WHERE EXISTSNODE(XML_DATA, '/Experiment/Parameters/Parameter[@col="H" and @row="试验1"]') = 1但是到c#程序中 ExecuteDataSet时 就或出现
不支持的 Oracle 数据类型 USERDEFINED
原来缺少getclobval()
1SELECT DOC_ID, EXTRACT(XML_DATA, '/Experiment/Parameters/Parameter[@col="H" and @row="试验1"]').getclobval()
2 FROM EXPERIMENTS
3 WHERE EXISTSNODE(XML_DATA, '/Experiment/Parameters/Parameter[@col="H" and @row="试验1"]') = 1
上面的写法在c#程序中执行才能通过
SELECT DOC_ID, EXTRACT(XML_DATA, '/Experiment/Parameters/Parameter[@col="H" and @row="试验1"]').getclobval() 2
FROM EXPERIMENTS 3
WHERE EXISTSNODE(XML_DATA, '/Experiment/Parameters/Parameter[@col="H" and @row="试验1"]') = 1
