asp调用oracle存储过程 的问题 大家帮忙看看
set conn = Server.CreateObject("ADODB.Connection")
connString = "Provider=MSDAORA;Data Source=ORA;User ID=my;Password=123"
conn.Open connString
Set cmd = Server.CreateObject("ADODB.Command")
with cmd
.ActiveConnection = conn
.CommandType = 1
.CommandText = "pr_author_query"
.Parameters.Append .CreateParameter( "inintsndaid" , adVarChar , adParamInput , 10 , "0" )
.Parameters.Append .CreateParameter( "invarpoptid" , adVarChar , adParamInput , 50 , "testuser" )
.Parameters.Append .CreateParameter( "inintbookid" , adInteger , adParamInput , 10 )
.Parameters.Append .CreateParameter( "inintebookid" , adInteger , adParamInput , 152165 )
.Parameters.Append .CreateParameter( "outresult" , adInteger , adParamOutput )
.Parameters.Append .CreateParameter( "outmesg" , adVarChar , adParamOutput )
.Execute
end with
response.write cmd("outresult")
conn.close
提示说.Parameters.Append .CreateParameter( "inintsndaid" , adVarChar , adParamInput , 10 , "0" ) 参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
请问这个怎么解决? 问题是出在哪里?