Home » Developer & Programmer » JDeveloper, Java & XML » How to generate XSL file from table data (9.2.0.8 AIX)
How to generate XSL file from table data [message #400790] Wed, 29 April 2009 10:14 Go to next message
Orna
Messages: 62
Registered: November 2008
Member
Hi

How can I generate XSL file from data stored in Oracle table ?

thanks
Orna

[Updated on: Wed, 29 April 2009 10:28]

Report message to a moderator

Re: How to generate XSL file from table data [message #400894 is a reply to message #400790] Thu, 30 April 2009 05:14 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Please explain..
What data do you have? What should the XSL look like?
Re: How to generate XSL file from table data [message #400941 is a reply to message #400894] Thu, 30 April 2009 08:27 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
Thank you for looking into this, Frank.

XSL should look like:

<?xml version="1.0" encoding="UTF-8" ?>
- <xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:fn="http://www.w3.org/2005/xpath-functions">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"
/>
- <xsl:template name="DomainLookup">
<xsl:param name="domainId" />
<xsl:param name="domainCode" />
- <xsl:if test="$domainId = 'GNLSTSTS'">
- <xsl:if test="$domainCode = 'N'">
<xsl:text disable-output-escaping="yes">Active</xsl:text>
</xsl:if>
- <xsl:if test="$domainCode = 'P'">
<xsl:text disable-output-escaping="yes">Pending</xsl:text>
</xsl:if>
</xsl:if>
</xsl:template>
</xsl:stylesheet>

The table contains domain data:

DOMAIN_CODE
CODE_VALUE

There is no PK, for the same domain code there will be many CODE_VALUE values.

Re: How to generate XSL file from table data [message #400955 is a reply to message #400941] Thu, 30 April 2009 11:00 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
How would you "generate" this XSL, based on solely your data & the layout of your table?
If you can't (well, I can't) how could Oracle?
There seems to be something missing: the translation algorithm/rules.
Previous Topic: OA Framework on 1159?
Next Topic: query to fetch an xmls's absolute xpath and value
Goto Forum:
  


Current Time: Thu Mar 28 17:28:56 CDT 2024