Hi,
I am using Oracle Enterprise Manager 11g 11.2.0.1.0.
I’m trying to do an XMLTransform using below:
SELECT xmlTransform(d.spl_document,
XDBURIType('/SPL_stylesheet/spl/spl.xsl').getxml()).getClobVal() HTML
FROM edrls_spl_documents d
where d.spl_root_id = '06721e95-f3e8-4ac2-917c-8cae9f0e440f';
spl_document is a XMLType colum that has the following XML:
<?xml version="1.0" encoding="UTF-8"?>
<document xmlns="urn:hl7-org:v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:hl7-org:v3 http://www.accessdata.fda.gov/spl/schema/spl.xsd">
<id root="06721e95-f3e8-4ac2-917c-8cae9f0e4422"/>
<code code="51725-0" codeSystem="2.16.840.1.113883.6.1" displayName="ESTABLISHMENT REGISTRATION"/>
<title/>
<effectiveTime value="20091024"/>
<setId root="423eb267-0420-4fa7-811b-6ba1d4805122"/>
<versionNumber value="1"/>
<author>
<time/>
<assignedEntity>
<representedOrganization>
<assignedEntity>
<assignedOrganization>
<id extension="739980712" root="1.3.6.1.4.1.519.1"/>
<name>Regname</name>
<contactParty>
<addr>
<streetAddressLine>55</streetAddressLine>
<city>Bridge</city>
<state>PA</state>
<postalCode>08807</postalCode>
<country>USA</country>
</addr>
<telecom value="tel:+1-555-555-7538"/>
<telecom value="mailto:mail@email.com"/>
<contactPerson>
<name>Contact Person</name>
</contactPerson>
</contactParty>
<assignedEntity>
<assignedOrganization>
<id extension="223243822"/>
<id extension="2213298"/>
<name>Ename</name>
<addr>
<streetAddressLine>Drive</streetAddressLine>
<city>City</city>
<state>MO</state>
<postalCode>55555</postalCode>
<country>USA</country>
</addr>
<contactParty>
<addr>
<streetAddressLine>Drive</streetAddressLine>
<city>City</city>
<state>NJ</state>
<postalCode>55555</postalCode>
<country>USA</country>
</addr>
<telecom value="tel:+1-555-555-555"/>
<telecom value="mailto:email@email"/>
<contactPerson>
<name>ContactName</name>
</contactPerson>
</contactParty>
</assignedOrganization>
<performance>
<actDefinition>
<code code="C43360" codeSystem="2.16.840.1.113883.3.26.1.1" displayName="MANUFACTURE"/>
</actDefinition>
</performance>
</assignedEntity>
</assignedOrganization>
</assignedEntity>
</representedOrganization>
</assignedEntity>
</author>
<component>
<nonXMLBody>
<text/>
</nonXMLBody>
</component>
</document>
The following Stylesheets are in the Oracle XML DB repository
http://www.fda.gov/downloads/ForIndustry/DataStandards/StructuredProductLabeling/UCM241514.zip
All XSL have been updated so that the local reference is to the Oracle Repository root directory. Example spl.xsl has been updated to:
<xsl:transform version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:v3="urn:hl7-org:v3">
<xsl:import href="/SPL_stylesheet/spl/spl-common.xsl"/>
<!-- Whether to show the clickable XML, set to "/.." instead of "1" to turn off -->
<xsl:param name="show-subjects-xml" select="/.."/>
<!-- Whether to show the data elements in special tables etc., set to "/.." instead of "1" to turn off -->
<xsl:param name="show-data" select="1"/>
<!-- Whether to show section numbers, set to 1 to enable and "/.." to turn off-->
<xsl:param name="css">/SPL_stylesheet/spl/spl.css</xsl:param>
<xsl:param name="show-section-numbers" select="/.."/>
<!-- Whether to process mixins (experimental) -->
<xsl:param name="process-mixins" select="true()"/>
<xsl:param name="core-base-url">http://www.accessdata.fda.gov/spl/stylesheet/core</xsl:param>
<xsl:output method="html" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:strip-space elements="*"/>
</xsl:transform>
When attempting the XMLTransform I get the following error:
LPX-00601: Invalid Token in '/@*|node()'
I feel that it is either a namespace issue, problems with the nested stylesheets or that the Oracle XSL processor will not work with the MSXSL namespace.
IE is able to render the XML with no issues.
Any help would be appreciated.
Thanks!
Edited by: 805731 on Apr 18, 2011 9:59 AM