I'm writing a function that will take a query and a stylesheet as parameters (varchar2), generate xml from the query, format the output using the supplied stylesheet and return it to the calling program.
I've based the function on code examples I've found on the web, so apologies if this isn't actually xml db.
The stylesheet is well-formed, according to xmlspy.
I've reduced the call down to this - xmldoc := dbms_xmlparser.parse(xsl);
This is the error:
Error at line 1
ORA-31001: Invalid resource handle or path name "<?XML VERSION="1.0"?>
<xsl:stylesheet VERSION="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:TEMPLATE match="ROWSET">
<SupportingData xmlns="http://www.moneo.co.uk/eXii">
<xsl:APPLY-templates SELECT="ROW"/>
</SupportingData>
</xsl:TEMPLATE>
<xsl:TEMPLATE match="ROW">
<Clients>
<xsl:APPLY-templates SELECT="CLIENT/CLIENT_ROW"/>
<xsl:APPLY-templates SELECT="SPOUSE/SPOUSE_ROW"/>
</Clients>
<ProductStartDate>
<xsl:VALUE-OF SELECT="PRODUCTSTARTDATE"/>
</ProductStartDate>
"
ORA-06512: at "SYS.XDBURITYPE", line 11
ORA-06512: at "XDB.DBMS_XSLPROCESSOR", line 142
ORA-29280: invalid directory path
ORA-29280: invalid directory path
ORA-29280: invalid directory path
ORA-06512: at "XDB.DBMS_XMLPARSER", line 41
ORA-06512: at line 402
I haven't posted the whole stylesheet, as I reckon the error is probabaly pretty basic, but I can't find out what it is.
I've got rather confused with the different ways I've found to manipulate xml in Oracle!
Thanks,
Graham
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production