Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Problem with a Oracle SP in ASP


Message #1 by "Vianneth Payan" <vpayan@p...> on Fri, 11 Jan 2002 16:02:25
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.

  Return to Index