Hello,
This is probably obvious, but I just haven't been able to figure it out.
I have a stored procedure that returns a return code, but not a resultset. The return codes are 0-4 and each mean something specific.
When I execute the stored procedure, I need to be able to retrieve the return code and use it in my xsl stylesheet.
I can't figure out what to put inside <esql:call-results> to retrieve this return code.
I have this code:
<xsl:template match="db_query:launch_search_xlpin">
<esql:execute-query>
<!-- Call sproc to launch cold/reverse finger search -->
<esql:call>
{call LaunchSearches(
<esql:parameter direction="in" type="String"><xsp-request:get-parameter name="xlpin"/></esql:parameter>,
2)}
</esql:call>
<esql:call-results>
<launch_searches_xlpin>
???? how to access the return code
</launch_searches_xlpin>
</esql:call-results>
</esql:execute-query>
</xsl:template>
The procedure is executing correctly, but I can't seem to get the return code. Any help/suggestions would be appreciated. Is there something to use beside <esql:call-results>??
thanks,
Beth Naquin
SAGEM MORPHO Inc.
1145 Broadway Plaza STE 200
Tacoma, WA 98402
253-597-8245