ASP > Calling a Stored Procedure

Created On: 1/23/2004 8:43:00 AM

Set oCommand = Server.CreateObject("ADODB.Command")
oCommand.ActiveConnection = oConn
oCommand.CommandText = "SP_NAME"
oCommand.CommandType = adCmdStoredProc
oCommand.Parameters.Append oCommand.CreateParameter ("@cPARAM1",advarchar,adParamInput,50,"Test 1")
oCommand.Parameters.Append oCommand.CreateParameter ("@cPARAM2",advarchar,adParamInput,50,"Test 2")
oCommand.Execute