Hi,<BR><BR>I am trying to pass an array to a stored procedure as an input parameter. My environment is VBScript ASP. Any ideas on how to do this? Your help is greatly appreciated!<BR><BR>My problem is with the "oCMD.Parameters.Append..." statement below - how do I specify that I am passing an array??<BR><BR>Some sample code is below:<BR><BR>Dim oCMD<BR>Dim oRS<BR>Dim aryInput(2)<BR><BR>aryInput(0) = "First"<BR>aryInput(1) = "Second"<BR><BR>Set oCMD = Server.CreateObject("ADODB.Command")<BR><BR>oCMD.A ctiveConnection = aDSNstring<BR>oCMD.CommandType = 1<BR>oCMD.Prepared = True<BR><BR>oCMD.CommandText = "{call stored_proc(?,{resultset 100, return_arr})}"<BR><BR>oCMD.Parameters.Append ocmd.CreateParameter("input_arr", adVarChar, adParamInput, 20, aryInput)<BR><BR>Set oRS = oCMD.Execute<BR><BR>