Re: Executing Procedures From Microsoft Access 97

On Fri, 13 Feb 1998 09:41:09 -0600, dosberg_at_yahoo.com wrote: Hi,

one way to do this is to execute a pass through query like this:

Begin <package name>.<procedure name>(par1, par2,..); end; Remember to enclose string parameters in single quotes like " 'CLINTON' ".

>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."
>
>Any advice or recommendations would be greatly appreciated.
>
>David Osberg
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de