Xquery no updating expression allowed

An error is never raised if no nodes are targeted, but updating SQL functions may raise an error if an XPath-expression argument targets inappropriate nodes, such as attribute nodes or text nodes. CREATE TABLE table_with_xml_column (filename VARCHAR2(64), xml_document XMLType); Table created.

INSERT INTO xml_table VALUES (XMLType(bfilename('XMLDIR', 'purchase Order.xml'), nls_charset_id('AL32UTF8'))); 1 row created. SELECT OBJECT_VALUE FROM purchaseorder WHERE exists Node(OBJECT_VALUE, '/Purchase Order[Special Instructions="Expedite"]') = 1; OBJECT_VALUE ---------------------------------------------------------------------------------- cannot, because it returns a scalar value (number).

Assignments typically allow a variable to hold different values at different times during its life-span and scope.(But you can keep the old version if you prefer.) If you ever hit a snag with Regex Buddy, check here whether you have the latest version.If you do, simply report the issue on the forum and we'll help you out as soon as we can.So don't worry if there might be a new major upgrade around the corner just because it's been a while since the last major upgrade.If there is one around the corner, you'll get it free, without having to ask.