Re: IIS Oracle Stored Procedures

Wouldn't you consider Oracle's webserver ????

Direct PL/SQL access, generating HTML as you like it !! N o more fuzzing around, no overhead on DB communication. Simply as fast as it gets !

For access restriction/authorisation purposes you can also use IIS as a listener.....

Take the easy path....

Regards,

Art Groeneveld
Oracle Systems Designer

Dave Monks wrote:

> 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 - 11:22:30 CDT