Hi,
I am calling the ORACLE procedure from ASP file as given below
dim return_code
dim cmd
dim lngrecs
set cmd = Server.CreateObject("ADODB.Command")
With cmd
.ActiveConnection = connection_string
.commandtype=4
.CommandText = "CS_OWNER.sp_authenticate"
.Parameters.append .createparameter("@i_uid",201,1,10)
.Parameters.append .createparameter("@i_pwd",201,1,10)
.Parameters.append .createparameter("@o_valid",3,2)
.Parameters("@i_uid") = emplid
.Parameters("@i_pwd") = pwd
.execute lngrecs, ,128
return_code = .Parameters("@o_valid")
End With
I am getting the error in the following line
.execute lngrecs, ,128
error message
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Oracle][ODBC]Syntax error or access violation.
/support/sales/order_entry/inc.asp, line 789
anybody can help me.
thanks in advance
Lava
2006-07-31
03:43:03
·
2 answers
·
asked by
Lava
1