Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-20100 when trying to open a document from within a StyleSheet
Trying to open a document from within a StyleSheet and I get this
error:
ORA-20100 Error occurred while processing:
file:/home/zjxc50/aseXML.xslt: XSL-1021:(Error)
Error parsing external document:'no protocol:Transactions_r13.xsd'.
This is for a developer, so please make any comments easy for a dumb DBA to understand. I've gone through Metalink, nothing relevant. Developer has checked the path and file permissions(so he says).
Here's the code:
DECLARE
lDir VARCHAR2(256);
lFile VARCHAR2(256);
lFileType VARCHAR2(32);
lParser XMLParser.Parser;
lProcessor XSLProcessor.Processor;
lStylesheet XSLProcessor.Stylesheet;
XSLDoc XMLDOM.DOMDocument;
BEGIN
lDir := '/home/zjxc50';
lFile := 'test00.txt';
lParser := XMLParser.NewParser;
XMLParser.setBaseDIR(lParser
,lDir);
XMLParser.SetPreserveWhiteSpace(lParser
,TRUE);
XMLParser.parse(lParser
,lDir || '/aseXML.xslt');
XSLDoc := XMLParser.GetDocument(lParser);
lStylesheet := XSLProcessor.NewStylesheet(XSLDoc
,NULL);
lProcessor := XSLProcessor.NewProcessor;
XSLProcessor.ProcessXSL(lProcessor
,lStylesheet ,lDir || '/aseXML_r13.xsd' ,lDir ,lFile);
<?xml version="1.0"?>
<?xmlspysamplexml \\sundev1\zjxc50\HUBDATA\XMLSchema\r13\aseXML_r13.xsd?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:output method="text" indent="no"/>
<xsl:param name="env"/>
<xsl:variable name="paraCount" select="count(//Parameter)"/>
<xsl:variable name="newline">
<xsl:text>
</xsl:text>
</xsl:variable>
<xsl:variable name="quote">
<xsl:text>'</xsl:text>
</xsl:variable>
<xsl:variable name="quote-double">
<xsl:text>''</xsl:text>
</xsl:variable>
<xsl:variable name="sep">
<xsl:text>/</xsl:text>
</xsl:variable>
<!--<xsl:variable name="fpath"
select="'\\sundev1\zjxc50\HUBDATA\XMLSchema\r13'"/>
-->
<xsl:variable name="fpath"
select="'/opt/app/Alinta/Dev/Env1/Data/XMLSchema/r13'"/>
<xsl:template match="/">
<xsl:for-each select="//@schemaLocation">
Element <xsl:value-of select="."/>
<xsl:if test="substring(.,1,12)='Transactions'">Crap
<xsl:value-of select="name()"/>=<xsl:value-of select="."/>;
<xsl:variable name="v_incl" ><xsl:value-of select="."/></xsl:variable>
<xsl:for-each select="document($v_incl)//*[name='NMIDiscoveryRequest']">
<xsl:value-of select="name()"/>=<xsl:value-of select="."/>;
</xsl:for-each>
</xsl:if>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
Received on Wed Feb 11 2004 - 22:57:22 CST
![]() |
![]() |