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_at_news02.btx.dtag.de>#1/1
End If
On Error GoTo 0
Exit Function
AuszahlungSpeichernFehler:
Date: 1998/06/05
Message-ID: <6l8ht2$qa5$1_at_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.deReceived on Fri Jun 05 1998 - 00:00:00 CEST