Oracle work notes, non-recurring updates

　　This blog for work, see the technical issues of the solution notes, Welcome to reprint, reproduced please indicate the source, thank you ~

　　

　　Update Time: 2017-07-12

　　1. When reading the Clob field value, the Oracle Datagram data type is inconsistent when borrowing the Extractvalue or extract function to read the node
　　

Solution: Data type issues, Guess 1. It is possible that the obtained node value conflicts with the desired value type, view SQL, discover that there is actually no association, if you can query out the node value, it must be the string type, there is no conflict, guess 2. There may be a null value problem, the Extractvalue function does not have a null error problem, guess 3: It is possible that the CLOB type does not support the Extractvalue function because Oracle has another field that is also the---sys.xmltype type that saves the XML string

Solution: If the XML field is CLOB type, then the XML fields are converted to the Sys.xmltype type, which is XmlType (XML), and if the Sys.xmltype type is used directly with the function

Oracle work notes, non-recurring updates