Re: ASP, ADO and ORACLE

Hi Ivana,

Sure it works! Just create a a command object and add your parameters to it.

<!--#include file="ADOVBS.INC"-->

Set con = Server.CreateObject("ADO.Connection") con.Open "dsn=Local;uid=username;pwd=passwd" con.CommandTimeout = 30
Set cmd = Server.CreateObject("ADODB.Command") Set cmd.ActiveConnection = con

cmd.CommandText = "DEMO_CUSTOMER_API.New" cmd.Parameters.Append cmd.CreateParameter("@Attrib", adVarChar, adParamInput, 32000)
cmd.Parameters.Append cmd.CreateParameter("@Info", adVarChar, adParamOutput, 2000)
...

Set rs = cmd.Execute(,,adCmdStoredProc) Response.Write(cmd("@Info")

con.Close

Regards,

--
Bobby

Ivana Smoljan wrote in message <6tnsmg$d60_at_as041.tel.hr>...
>Hello!
>
>Does anyone have an answer for this?
>I'm trying to call Oracle functions and stored procedures (procedures that
>are in
>packages) from ASP, using ADO 2.0 .
>Does anyone know if that is possible at all and how do I do that ??
>Stored procedures that are NOT in packages work just fine (with Command
>object ...)
>
>Thanks a lot!!!
>
>
>
Received on Wed Sep 16 1998 - 13:53:21 CDT