Oracle Stored Procedures from asp
am 09.03.2005 18:58:11 von ken.kennedyI'm having some problems calling a stored procedure from an ASP page.
When testing the page I get the error message
"Microsoft OLE DB Provider for Oracle error '80040e14'
Syntax error in {call...} ODBC Escape."
The code I'm using is as follows (names changed to protect the
innocent of course)
With ObjCmd
.ActiveConnection = strExpandConn
.CommandText = "{call Packagename.ProcedureName({resultset
100,det_return})}"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("Agr_Num", adBSTR,
adParamInput)
.Parameters("Agr_Num") = AgreementNumber
set ObjRS = .execute
end with
Any advice would be appreciated