Hi ,

I need to pass 5 dynamic values to my stored procedure. These values
are stored in 5 different variables (policy variables). I have followed
'Cool Solutions: Calling Stored Procedures with the IDM JDBC Driver'
(http://www.novell.com/coolsolutions/feature/19969.html) and with 5
static values it works.

My GCV is:

<definition display-name="CALL-STORED-PROCEDURE-UP" multi-line="true"
name="CALL-STORED-PROCEDURE-UP" type="string">
<value>&lt;nds>
&lt;input xmlns:jdbc="urn:dirxml:jdbc">
&lt;jdbc:statement event-id="0">
&lt;jdbc:call-procedure jdbc:name="dbo.ZZZ_IDM_UP">
&lt;jdbcaram jdbc:name="@id_utente">
&lt;jdbc:value>167&lt;/jdbc:value>
&lt;/jdbcaram>
&lt;jdbcaram jdbc:name="@utente">
&lt;jdbc:value>msbraccia&lt;/jdbc:value>
&lt;/jdbcaram>
&lt;jdbcaram jdbc:name="@id_livello_accesso">
&lt;jdbc:value>50&lt;/jdbc:value>
&lt;/jdbcaram>
&lt;jdbcaram jdbc:name="@id_area_lav">
&lt;jdbc:value>2&lt;/jdbc:value>
&lt;/jdbcaram>
&lt;jdbcaram jdbc:name="@disabilitato">
&lt;jdbc:value>SI&lt;/jdbc:value>
&lt;/jdbcaram>
&lt;/jdbc:call-procedure>
&lt;/jdbc:statement>
&lt;/input>
&lt;/nds> </value>
</definition>

How can I pass 5 dynamic values to my stored procedure? Can I put the
variable name in the value parameter, like "<value>$var_name</value>"?

thanks in advance


--
dpanichi
------------------------------------------------------------------------
dpanichi's Profile: http://forums.novell.com/member.php?userid=20142
View this thread: http://forums.novell.com/showthread.php?t=422497