IIS Oracle Stored Procedures

From: Dave Monks <DMonks_at_CompassC.Demon.Co.UK>
Date: Thu, 15 Jul 1999 12:15:10 +0100
Message-ID: <932037477.9407.0.nnrp-01.9e98ba5c@news.demon.co.uk>

Does anyone know how to execute a stored procedure in an Oracle database from an ASP script so that I can pass parameters to and from the procedure.

The code I was using for MSSQL Server was:

set cmd = Server.CreateObject ("ADODB.Command")

cmd.ActiveConnection = cn
cmd.CommandText = "{call SalesOrgNew (?,?,?,?,?,?,?,?)}"
cmd.CommandType = 1
cmd.parameters.refresh
cmd.parameters("@SalesOrgID") = SalesOrgID
cmd.parameters("@SalesOrgCode") = SalesOrgCode
cmd.parameters("@SalesOrgName") = SalesOrgName
cmd.parameters("@Status") = Status
cmd.parameters("@CreatedBy") = Session("UserName")
cmd.parameters("@CreatedOn") = date()   cmd.parameters("@ActiveStart") =

cdate(ActiveStart) cmd.parameters("@ActiveEnd") = cdate(ActiveEnd) cmd.execute recordsaffected
SalesOrgID = cmd.parameters("@SalesOrgID")

Trying to use the same code with Oracle gives me the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e51' The provider cannot derive parameter info and SetParameterInfo has not been called

Anyone any ideas ?

Thanks in advance for any help received.

Dave Monks Received on Thu Jul 15 1999 - 06:15:10 CDT