Calling Oracle 8 Stored Procedure via Access 2000/3 or Visual Basic -
04-01-2004
, 06:15 PM
Does anybody know how to call and execute an Oracle 8 Stored Procedure via
ODBC or OLEDB, ADO or preferrably a Access passthrough query.
The Stored Procedure runs Delete statements against tables in the database
which is much faster than executing deletes against tables tables linked to
Oracle in Access.
I have tried the following Syntax:
{Call sp_DELETETABLE()}
{Begin
Call sp_DELETETABLE()
End;}
I can execute the sp_DELETETABLE in PL / SQL with no problems.
Thanks! |