Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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