大虾们帮忙?asp调SYBASE 的存储过程的错误
GEN#R_TRANEXECTOTAL这个存储过程需两个参数
Set Cmd=Server.CreateObject("ADODB.Command")
Cmd.ActiveConnection=DSN
Cmd.CommandText="GEN#R_TRANEXECTOTAL"
Set Parm1=Cmd.CreateParameter("@KEYNOSTR",AdChar,adParamInput,12,keyno)
Cmd.Parameters.Append Parm1
Set Parm2=Cmd.CreateParameter("@INT_CONDITION",AdSmallInt,adParamInput,,0)
Cmd.Parameters.Append Parm2
rstemp.Open Cmd
运行时总是出现这种错误:
[INTERSOLV][ODBC SQL Server driver][SQL Server]Procedure GEN#R_TRANEXECTOTAL expects parameter @KEYNOSTR, which was not supplied.
请问如何解决?