Hi,

Have a look at the xslt code that calls a stored procedure.
This procedure returns a value and the value is stored in the oracle variable res. I need to store the same in a xslt variable.

<jdbc:statement jdbc:transaction-type="auto" type="update">
<jdbc:sql>
 <xsl:text>declare res varchar2(500); begin res := </xsl:text>
 <xsl:text>\{Call </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="document ('vnd.nds.stream:./config#XmlData')//action-indicators/object-add/text()"/>
 <xsl:text>)};</xsl:text>
 <xsl:text>end; </xsl:text>
</jdbc:sql>
/jdbc:statement>

Thanks in advance.