I'm trying to call a stored procedure on the subscriber channel that will
update the Oracle database directly, instead of updating a table or view.

Below is a copy of the stylesheet I'm using which doesn't work (I'm very
new to this). What's missing and where should this be placed, in the
Event Transform?

Any help would be much appreciated.



<?xml version="1.0" encoding="UTF-8"?><xsl:stylesheet exclude-result-
prefixes="query cmd dncv" version="1.0"
xmlns:cmd="http://www.novell.com/nxsl/java/com.novell.nds.dirxml.driver.Xd
sCommandProcessor"
xmlns:dncv="http://www.novell.com/nxsl/java/com.novell.nds.dirxml.driver.D
NConverter" xmlns:jdbc="urn:dirxml:jdbc"
xmlns:query="http://www.novell.com/nxsl/java/com.novell.nds.dirxml.driver.
XdsQueryProcessor" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<!-- parameters passed in from the DirXML engine -->
<xslaram name="srcQueryProcessor"/>
<xslaram name="destQueryProcessor"/>
<xslaram name="srcCommandProcessor"/>
<xslaram name="destCommandProcessor"/>
<xslaram name="dnConverter"/>
<xslaram name="fromNds"/>
<!-- identity transformation template -->
<!-- in the absence of any other templates this will cause -->
<!-- the stylesheet to copy the input through unchanged to the
output -->
<xsl:template match="node()|@*">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<!-- add your custom templates here -->
<jdbc:statement>
<jdbc:sql> call procedure update_appl(muPIDM, muBadgeType,
muBadgeBarCode, muBadgeID) </jdbc:sql>
</jdbc:statement>
</xsl:stylesheet>