Re: Vb calling Oracle db procedures

From: Hugh Pendry <hpendry_at_trinitech.co.uk>
Date: Wed, 21 Oct 1998 10:07:06 +0100
Message-ID: <70k8a8$jqg$1@trinitech.demon.co.uk>

Hi chris

I am having a similar problem calling an oracle stored function from vb to return a result set.

The syntax for calling a stored function is:-

Private Sub Command1_Click()
Dim db As New rdoConnection
Dim qd As rdoQuery
Dim sql As String

    db.Connect = "DSN=myDSN"
    db.EstablishConnection

    sql = "{ ? = Call optionalPackageName.funcName(?, ?, ?) }"

    Set qd = db.CreateQuery("myQry", sql)

    qd.rdoParameters(0).Direction = rdParamReturnValue

    qd(1) = "Val1"
    qd(2) = 2
    qd(3) = 10.738

    qd.Execute
    Debug.Print "Result is: " & CStr(qd(0)) End Sub

If you have any luck with an oracle stored function returning a result set please let me know.

thanks
hugh

Chris Powell wrote in message <362AD2AC.D1767459_at_helix.com.au>...
>Help....
>
>We have developed a new applicvation in VB and wish to call
>some
>database procedures, passing some variables. and returning
>others.
>
>I need to know the correct syntax to run an Oracle 7.3.2 db
>procedure
>from Visual Basic 6.
>At present we are having no luck running the procedures!
>
>Any help would be greatly appreciated.
>
>Thanks in Advance.
>
>Chris
>
Received on Wed Oct 21 1998 - 04:07:06 CDT