Oracle Stored Procedure

[DRRAZGU]

What is the best way to call an oracle stored procedure from Access 97? I need to update an existing Oracle 9i table with data passed from VBA. Security wont let me attach the table. They will allow me to call a stored procedure to update the record.

 

[mibeach7]

build a macro to RunCode()
then add this code in a module...
Public Function DATA_PULL()

Dim MyCon As ADODB.Connection
'Dim MyDB As Database

'****************************************************************
Set MyCon = New ADODB.Connection
MyCon.ConnectionString = "DSN=PHARM92;UID=PHARM;PWD=DRUG;"
MyCon.CommandTimeout = 0

'Set MyDB = CurrentDb

'****************************************************************
MyCon.Open
MyCon.Execute ("TRUNCATE TABLE OPS.CARDS_PROCESSING;&quot
MyCon.Execute ("BEGIN OPS.CARDS_PULL(); END;&quot'Oracle Proc
MyCon.Close

Set MyCon = Nothing
'Set MyDB = Nothing


End Function