Re: Executing Procedures From Microsoft Access 97

dosberg_at_yahoo.com wrote in message <887384299.334823435_at_dejanews.com>...
>I have inherited an Oracle database with an Access client(front end). I
>want to kick off an Oracle procedure using an Access pass-through query.
>I have tried several syntax variations but keep getting an error message
>telling me "invalid SQL Statement."

Try wrapping the stored procedure call with begin and end, e.g.

BEGIN; package1.sp2('var1'); END

It works in Delphi and VB, so I guess it will work in Access too.

regards,
Billy Received on Mon Feb 16 1998 - 00:00:00 CST