Home » Developer & Programmer » JDeveloper, Java & XML » Can't call Oracle Stored Procedure in ASP
Can't call Oracle Stored Procedure in ASP [message #91122] Wed, 17 April 2002 05:51 Go to next message
rama kanth
Messages: 4
Registered: April 2002
Junior Member
I can't call the ORACLE STORED PROCEDURE i am getting error as WHERE AS THE SAME IS RUNNING IN VISUAL BASIC

ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

MY STORED PROCEDURE

CREATE OR REPLACE PROCEDURE SP_INFLOW (res IN NUMBER, st_dt IN DATE ,end_dt IN DATE) IS

// Logic goes here

MY ASP CODE COMMAND OBJECT CODE IS

SET cmds=SERVER.CREATEOBJECT("ADODB.command")

WITH cmds
.CommandText = "SP_INFLOW"
.CommandType = adCmdStoredProc
SET byparam = .CreateParameter("res", adInteger, adParamInput,,1)
SET byparam1 = .CreateParameter("st_dt", adDate, adParamInput,,12-jul-95)
Set byparam2 = .CreateParameter("end_dt", adDate, adParamInput,,15-jul-95)

.Parameters.Append byparam
.Parameters.Append byparam1
.Parameters.Append byparam2
Set .ActiveConnection = Application("Conn").Execute
END WITH

THE SAME CODE IS RUNNING WITH VISUAL BASIC
I HAVE CHECKED THE DATE FORMAT : IT IS FINE
I HAVE CHECKED DRIVER : IT IS SAME AS IN VB
PLEASE TELL ME WHAT IS THE PROBLEM WITH THE ABOVE
Re: Can't call Oracle Stored Procedure in ASP [message #91293 is a reply to message #91122] Wed, 03 July 2002 04:52 Go to previous messageGo to next message
Richard
Messages: 44
Registered: May 2000
Member
Refresh the componente Microsoft ADO 2.6.
Download of http://www.microsoft.com/data/download.htm
Re: Can't call Oracle Stored Procedure in ASP [message #91445 is a reply to message #91122] Mon, 09 September 2002 11:39 Go to previous message
Bob
Messages: 49
Registered: March 1999
Member
ASP does not have the constants for ADO by default (e.g. adInteger, adParamInput). You will need to refer to them by number. adInteger = 3, adParamInput = 1.
Previous Topic: Re: Exception in thread "main" Java.lang.NoClassDefFoundError:dbas.
Next Topic: JDBC connection charset
Goto Forum:
  


Current Time: Wed Jul 28 20:32:00 CDT 2021