asp调用存储过程

OraDatabase.Parameters.Add"字段",页面变量值,1     (IN) 

OraDatabase.Parameters("IN_SESSION_ID").serverType=1 (1:VChar;2:Number)

……

……

OraDatabase.Parameters.add"字段",页面变量值,2  (OUT) 

OraDatabase.Parameters("OUT_SYORI_KBN"),serverType=1 (1:VChar;2:Number)

sql文:

    Begin 存储过程表名 (

                     :字段,

                     :字段,

                     :字段,

                     :字段,

                     …………

 );END

sqlCnt = DB_EXECUTE(sql文)

取OUT值

session_ID = OraDatabase.Parameters("IN_SESSION_ID")

OraDatabase.Parameters.Remove("IN_SESSION_ID")

OraDatabase.Parameters.Remove("…………")

OraDatabase.Parameters.Remove("…………")

OraDatabase.Parameters.Remove("…………")

……………………     ……………………

OraDatabase.Parameters.Remove("…………")