There is an example of getting the value of an output parameter on aspdb.com [see below]. However, when I try this example with a MS SQL Server stored procedure the value is not in a Session value like is indicated in the example. I am using aspdb classic. Am I missing something or is this not an option in classic?
<%
Set Y=Server.CreateObject("ASP.DB")
Y.dbUnit=5
Y.dbDBType="SQL"
Y.dbDSN="Provider=MSDAORA; data source=dell500; user id=scott; password=tiger"
Y.dbStoredProcCmdParams="(;~){? = call ExFunct(?,?)}~1~NORS;Res~139~2~10;Num1~139~1~5~19; Num2~139~1~5~18"
Y.dbDisplay=false
Y.ASPDB
response.write("<B>Input values Num1, Num2 = 19 and 18<BR>")
response.write("Res holds the returned value of function of num1 + Num2 in a session variable SV_SP_Unit_VarName =" & session("SV_SP_5_res") & "</B>")
%>
Note: The returned variable is defined as Res~139~2~10 where 2 = Output. VarName=Res