| Can't call Oracle Stored Procedure in ASP [message #91122] |
Wed, 17 April 2002 05:51  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
