Access and Oracle Stored Procedures

From: Gerald Caldwell Jr. <GeraldCaldwell_at_Minspring.com>
Date: 1999/03/12
Message-ID: <7cb3p0$knh$1@samsara0.mindspring.com>#1/1

Does anyone have and information on how to call oracle stored procedures from access.

Example.

I have a stored procedure in oracle that returns a persons name and adress base on a phone number.
I want to be able pass the phone number to the stored procedure as a parameter and return the address and name via the remaining parameters.

          GetCustomerInfo ( telephone,
                                          Last,
                                           first,
                                           street number,
                                           street_name,
                                           city,
                                           state,
                                           zip);

All of the parameters are declared as IN OUT and VARCHAR2 in the stored procedure.

How can I get this call to work from Access.

Thanks in advance

Gerald Caldwell Received on Fri Mar 12 1999 - 00:00:00 CST