Re: Running Oracle PL/SQL procedure via MS-Access

Hello Shane,

You tried SQL Pass-Through, and it wouldn't work!?! SQL Pass-Through should work. Are you using the latest version of the Oracle drivers? and the latest version of ODBC?

If so, and you still can't execute a procedure directly from Access, here is a work-a-round. Create a table on the Oracle box. Name it RunMe, or something. Put one text field in it (optionally, you could use several fields, one for the procedure name, the other(s) for arguments). Place an insert trigger on the table that will take whatever value is in the added record and run that procedure. Then, simply do not add the record to the table. The table takes up no real space, and it allows you to run the procedures.

To run the procedure from Access, simply attach the table and whenever you want to run a procedure, add a record to the table consisting of the procedure name, and whatever arguments you wish to pass, and boom, the procedure will run. As an alternative, you could use a SQL Pass-Through "INSERT INTO" statement rather than having the table attached.

I hope this helps,

Larry Tubbs, MCPS, MCSD
Silverleaf Vacation Club
mailto:ltubbs_at_sprintmail.com

Shane Murray <murraysa_at_gnpr.pae.osd.mil> wrote in article <33426F00.446B9B3D_at_gnpr.pae.osd.mil>...
> Is it possible to execute an Oracle stored PL/SQL procedure via
> MS-Access (i.e. ODBC).
>
> Access2.0, but have ability to use Access95 or Access97 (with 32-bit
> ODBC).
>
> --Shane Murray
>
> I have tried using Sql Passthrough queries to no avail.
>
Received on Thu Apr 03 1997 - 00:00:00 CST