Re: IIS Oracle Stored Procedures

From: <mtirving_at_my-deja.com>
Date: Fri, 16 Jul 1999 13:44:27 GMT
Message-ID: <7mncvo$fil$1@nnrp1.deja.com>

'Open a database connection
Set objCONN = Server.CreateObject("ADODB.Connection") objCONN.Open "Data Source=MyDatabase", "User", "password"

'To call a procedure
Set objSeqCM = Server.CreateObject("ADODB.Command")

objSeqCM.ActiveConnection = objCONN
objSeqCM.CommandText = "{ call procedure(?, ?, ?) }"
objSeqCM.CommandType = 1 'adCmdTxt
objSeqCM.Parameters(0).value = Param1
objSeqCM.Parameters(1).value = Param2
objSeqCM.Parameters(2).value = Param3
objSeqCM.Execute

'To call a function
Set objSeqCM = Server.CreateObject("ADODB.Command")

objSeqCM.ActiveConnection = objCONN
objSeqCM.CommandText = "{? = call get_temp_seq }"
objSeqCM.CommandType = 1 'adCmdTxt

session("SeachTableSeq") = objSeqCM.Parameters(0).value objSeqCM.Execute
session("SeachTableSeq") = objSeqCM.Parameters(0).value

If you have any other questions, drop me a line mirving_at_u1.net

-Mike

In article <378E0A69.B5E3535A_at_altavista.net>,   "A.W. Groeneveld" <awgroeneveld_at_altavista.net> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 16 1999 - 08:44:27 CDT