Hi, I'm getting the following error when I try to use ora:node-set function in the DB Engine:
ORA-31011: Fallo en el análisis de XML
ORA-19202: Se ha producido un error en el procesamiento
LPX-00607: Invalid reference: 'node-set'. de XML
ORA-06512: en "SYS.XMLTYPE", línea 187
ORA-06512: en línea 53
31011. 00000 - "XML parsing failed"
*Cause: XML parser returned an error while trying to parse the document.
*Action: Check if the document to be parsed is valid.
This is how I import the ora functions definition in the XSL file:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ora="http://schemas.oracle.com/xpath/extension" extension-element-prefixes="ora">
And this is how I call the node-set function:
<xsl:variable name="sortedSet" select="ora:node-set($sortedDetIvaList)"/>
The PL/SQL where I'm applying the XSL to the XML Data is the following:
xslFile := XMLTYPE(BFileName('XSLTFILES', 'createFile.xsl'), nls_charset_id('UTF8'));
transformedXml := xmlData.TRANSFORM(xslFile);
clobData := transformedXml.getClobVal();
* xmlData is a XMLTYPE variable where I have the XML Data
Am I doing something wrong?
Thanks in advance