I have a problem calling an Oracle SP in ASP
this is my code, problem below:
Set comando = Server.CreateObject("ADODB.Command")
With comando
.ActiveConnection = conexion
.CommandText = "NAME"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter ("@separador",
adVarWChar, adParamInput, 2, separador)
.Parameters.Append .CreateParameter ("@compania",
adDouble, adParamInput, , COMPANIA)
.Parameters.Append .CreateParameter ("@sucursal_internet",
adInteger, adParamInput, , sucursal_internet)
.Parameters.Append .CreateParameter ("@modulo", adInteger,
adParamInput , , modulo)
.Parameters.Append .CreateParameter ("@transaccion",
adInteger, adParamInput , , transaccion)
.Parameters.Append .CreateParameter ("@referencia",
adInteger, adParamOutput , 4)
.Parameters.Append .CreateParameter ("@respuesta",
adVarWChar, adParamOutput, 2)
.Parameters.Append .CreateParameter ("@mensaje",
adVarWChar, adParamOutput , 1000)
.Execute varSalida, , adExecuteNoRecords
mensaje = .Parameters("@mensaje")
End With
***********
The problem is:
Microsoft OLE DB Provider for ODBC Drivers
error '80040e21'
[Microsoft][ODBC Driver Manager] SQL data type out
of range
in the code line:
.Execute varSalida, , adExecuteNoRecords
are there some problem with data types on Oracle?
if I canīt use adInteger or AdDouble Types, Wich one should I use?
Thanks.