Re: Calling Stored Proc with Cursor from ASP

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
>
>
Received on Wed Apr 21 1999 - 08:37:35 CDT