asp调用oracle存储过程的问题

[simondxw]

在oracle里建立一个存储过程“asp_save(sFileName VARCHAR2)”
用asp调用老是报错
set oCmd = Server.CreateObject("ADODB.Command")
Set oCmd.ActiveConnection = conn
oCmd.CommandType = 4
oCmd.CommandText = "asp_save"
oCmd.Parameters.Append oCmd.CreateParamet("sFileName",adVarChar,adParamInput)
oCmd("sFileName") = "test"
oCmd.Execute
请问怎么样在asp里调用oracle的存储过程啊？

[standy]

'procedure sz_test_standy(p_A IN VARCHAR2,p_OUT OUT VARCHAR2 )
'ASP Server 通过Oracle Client连接DB哦

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=MSDAORA.1;User ID=uid;Data Source=TEST;Persist Security Info=False;PASSWORD=psw"
Set cmdTemp=Server.CreateObject("ADODB.Command")
cmdTemp.CommandText="SZ_TEST_STANDY"
cmdTemp.CommandType=4
Set cmdTemp.ActiveConnection=conn
cmdTemp.Parameters("P_A")="TEMP"
cmdTemp.Execute
RESPONSE.Write cmdTemp.Parameters("P_OUT")
%>