各位大虾帮忙look一下！

rui0354 2003-10-10 10:24:59

兄弟做了一个调用oracle存储过程的asp页面，代码如下:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>


<%
Dim cmdStoredProc,strOut,lngRecs

set cmdStoredProc = Server.CreateObject("ADODB.Command")
with cmdStoredProc
.ActiveConnection = OraDatabase
.CommandText = "monitor_total_make_p"
.CommandType = adCmdStoresProc
.Parameters.append Parameters.createParameter("m_monitor_code",adVarWChar,_
adParamInput,12,"0005")
.Parameters.append Parameters.createParameter("m_begin_date",adVarWChar,_
adParamInput,12,"2003-04-03")
.Parameters.append Parameters.createParameter("m_end_date",adVarWChar,_
adParamInput,12,"2003-04-03")
.Parameters.append Parameters.createParameter("m_total_type",adVarWChar,_
adParamInput,12,"1")
.Parameters.append Parameters.createParameter("m_max_serial",adVariant,_
adParamOutput)
'.Parameters.refresh
'.Parameters("m_monitor_code") = "0001"
'.Parameters("m_begin_date") = "2003-02-10"
'.Parameters("m_end_date") = "2003-02-10"
'.Parameters("m_total_type") = "1"
.execute lngRecs
strOut = "strOut="
strOut = strOut&.Parameters("m_max_serial")

end with
response.Write(lngRecs)
'response.Write("strOut=")
response.Write(strOut)

%>
其中OraDatabase为connection对象，语法没错，但是m_max_serial参数并没有输出，这是为何?!(monitor_total_make_p是存储过程名，m_monitor_code,m_begin_date,m_end_date,m_total_type为varchar2类型的输入参数，m_max_serial为number类型的输出参数！

...全文