Re: Calling Oracle stored procedure from MS Access

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/06/05
Message-ID: <6l8ht2$qa5$1@news02.btx.dtag.de>#1/1

Hi,

heres's an VB3 example which may give you some hints.

Function fSaveData () As Integer
'Calls SP to save data
Dim szLclSQL As String

On Error GoTo AuszahlungSpeichernFehler

    If fDatenPlausibel() Then

        
        szLclSQL = "BEGIN PACK_PROVABRECHNUNG.NEUEAUSZAHLUNG("
        szLclSQL = szLclSQL & wKB & ","
        szLclSQL = szLclSQL & Trim$(sitxtDollars) & "." &
Format$(sitxtCents, "00") & ","
        szLclSQL = szLclSQL & "'" & sitxtDate & "',"	-- be aware that
String parameters must be enclosed by "'"!
        szLclSQL = szLclSQL & dwModReason
        szLclSQL = szLclSQL & ");END;"
        
        fSaveData = (dbGblMakler.ExecuteSQL(szLclSQL) > 0)
        
    Else
        fSaveData = False

    End If
    On Error GoTo 0
    Exit Function
AuszahlungSpeichernFehler:

    MsgBox Error, MB_FEHLER, Str$(Err)
    fSaveData = False
    On Error GoTo 0
    Exit Function
End Function

Ashish Sahasra schrieb:
>
> Can someone help me to call Oracle stored procedure from MS Access?
> Any help is appriciated.
>
> Thanks in advance
>
> -Ashish

--

Regards

Matthias Gresz    :-)

GreMa_at_t-online.de

Received on Fri Jun 05 1998 - 00:00:00 CDT