Hi,

I am trying to use the command object to call a stored procedure, I use the

sintax indicated in the beginning ASP chapter 14, but I get a Parameter

Error:



The code is:



set objComm = Server.CreateObject("ADODB.Command")



 objComm.ActiveConnection = strConnect

 objComm.CommandText = "getinstancefromlogin"

 objComm.CommandType = adCmdStoredProc

 objComm.Parameters.Append

objComm.CreateParameter("login",adVarChar,adParamInput)

 objComm.Parameters.Append

objComm.CreateParameter("login",adBstr,adParamInput)

 objComm.Parameters("login") = strLogin



 objComm.Parameters.Append

objComm.CreateParameter("instanceid",adInteger,adParamOutput)

 objComm.Parameters.Append

objComm.CreateParameter("status",adInteger,adParamOutput)



 intInstanceIDCliente = objComm.Parameters("instanceid")

 strStatusCliente = objComm.Parameter("status")



I anybody knows and can tell me, where can i find information relating

calling stored procedures with the command object I will appreciatte that!,

I am using an Oracle Datbase.



Thank you and best regards

Carlos Alejandro Villegas

----------------------------------------------------------------------------

"La vejez es cuando sabes todas las respuestas

pero nadie te hace preguntas."

................................ Laurence J. Peter