Execute Oracle Stored Procedure from MS Access

[Guest]

Hi,

Is there a way to execute an Oracle stored procedure from MS Access ?

Thanks for the idea.

Gabriel

 

['69 Camaro]

Hi, Gabriel.

You can use a SQL Pass-Through Query or you can use VBA code to execute the
Oracle stored procedure. You can find examples of the syntax for the SPT on
this Web page:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&c2coff=1&th=b29547ad206293d9&rnum=16

And you can find many examples of the syntax for the VBA in discussion
threads listed on this Web page:

http://groups.google.com/groups?as_...p=microsoft.public.access.*&lr=&num=100&hl=en

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)