Get Output value of StoredProcedure.

Namespace:  Tornado
Assembly:  Tornado (in Tornado.dll) Version: 12.6.0.9 (1.0.0.0)

Syntax

C#
public string Get_SPOutput(
	string VarName
)
Visual Basic (Declaration)
Public Function Get_SPOutput ( _
	VarName As String _
) As String

Parameters

VarName
Type: System..::.String
@VariableName

Return Value

Dim ret as string = obj.Get_SPOutput("", VariableName)

Remarks

Cut and Paste example and adust DSN to match your setup.

Examples

CopyVB.NET
<script language='vb' runat='server'>
Sub Page_Load(Source as Object, E as EventArgs)
   Dim spio As New ASPDBNET.z()
   Dim sp As String = "SPname=BONUS_INCREASE|SPType=Table|NoRS=false;"
   sp &= "Name=p_bonusfactor|Type=decimal|Dir=in|Size=3|Value=1.5,"
   sp &= "Name=p_bonusmaxsumfordept|Type=decimal|Dir=in|Size=9|Value=100.0,"
   sp &= "Name=p_deptswithoutnewbonuses|Type=VarChar|Dir=out|Size=255,"
   sp &= "Name=p_countdeptsviewed|Type=integer|Dir=out|Size=4,"
   sp &= "Name=p_countdeptsbonuschanged|Type=integer|Dir=out|Size=4,"
   sp &= "Name=p_errormsg|Type=VarChar|Dir=out|Size=255"
   With spio
   .dbQP = "u=123|dt=DB2|pv=DB2|D=ULTRA;SAMPLE;Frank;z|ps=-1|ni=none|sb=none|th=tit=IBM DB2-9 SP"
   .dbStoredProcCmdParams = sp
   .ASPDBSP()
   End With
   Response.Write("<center><b>Return value p_deptswithoutnewbonuses=" & 
spio.Get_SPOutput("p_deptswithoutnewbonuses") & "</b><P></center>")
   Response.Write("<center><b>Return value p_countdeptsviewed=" & 
spio.Get_SPOutput("p_countdeptsviewed") & "</b><P></center>")
   Response.Write("<center><b>Return value p_countdeptsbonuschanged=" & 
spio.Get_SPOutput("p_countdeptsbonuschanged") & "</b><P></center>")
   Response.Write("<center><b>Return value p_errormsg=" & 
spio.Get_SPOutput("p_errormsg") & "</b><P></center>")
End Sub 
</script>

See Also