Hi,

I'm calling a oracle function from XSLT which will return a string.
The problem is, returned value will be stored in a oracle variable
l_result which is inside the pl-sql code. I need this return value to be
stored in a xslt variable. How to achieve this?
xslt code is give below for your reference.

<xsl:variable name="cmdInput">
<input>
<jdbc:statement jdbc:transaction-type="auto" type="update">
<jdbc:sql>
<xsl:text>declare l_result varchar2(500); begin l_result :=</xsl:text>
<xsl:value-of select="$procedure-name"/>
<xsl:text>('</xsl:text>
<xsl:value-of select="$cn"/>
<xsl:text>','</xsl:text>
<xsl:value-of select="$action-indicator"/>
<xsl:text>',</xsl:text>
<xsl:value-of select="$final-attrvalue"/>
<xsl:text>);</xsl:text>
<xsl:text>end;</xsl:text>
</jdbc:sql>
</jdbc:statement>
</input>
</xsl:variable>
<xsl:variable name="returnValue" select="cmd:execute
$destCommandProcessor,$cmdInput)"/>

Thanks in advance.

Vijay