Re: Calling Stored Proc with Cursor from ASP

Marek Suchomski wrote in message <7fkkbc$ph5$1_at_autumn.news.rcn.net>...
>I was able to get that far on my own. It's the "easily adapting the code
to
>VBScript" that is giving me the problems. If I do it like this:
>
> Set cmd = CreateObject("ADODB.Command")
> Set cmd.ActiveConnection = AdvanceConnect
> cmd.CommandText = "{ ? = call cur_pkg.www_func('" & userid & "')}"
> cmd.CommandType = adCmdStoredProc
> set RS2=cmd.execute
>
>I get an unbound variable error. So, I tried using this:
>
> cmd.Parameters.Append

cmd.CreateParameter("RS2",advarchar,adparamoutput)
> cmd.Execute
>
>in place of the set RS2... and I got an invalid parameter definition. Any
>help would be appreciated.
>
>Marek Suchomski
>suchomski_at_bsr.com
>
>
>Finn Ellebaek Nielsen wrote in message <7fk2ph$k38$1_at_news.inet.tele.dk>...
>
>>Using RDO 2.0 from Visual Baisc and the Oracle ODBC 8.0.5 driver (the
first
>>version to support this) you would have the following code, first the
>PL/SQL
>>package, then the Visual Basic code:
>>
>>I'm sure you can easily adapt the code above to VBScript.
>>
>>HTH.
>>
>>Finn
>>
>>
>
>

In ASP you have to use Server.CreateObject instead of CreateObject. Does that help?

Finn Received on Wed Apr 21 1999 - 12:56:21 CDT