MSAccess into Oracle's procedures, and procedure variables

From: Mark Hammond <MHammond_at_cmutual.com.au>
Date: Wed, 30 Nov 1994 03:22:19 GMT
Message-ID: <D029D8.KMJ_at_cmutual.com.au>


Hi all,

        Our oracle database has a number of database procedures we would like to call from MS-Access.

The procedure looks something like:

PROCEDURE test (in_param IN NUMBER, out_param IN OUT VARCHAR2) IS ...

I can successfully call this procedure from access. However, I can not see a technique to extract the value returned in out_param.

Does anyone have an ODBC solution to this? Does Oracle Glue provide a solution?? Is there _any_ solution??

Thanks in advance. Mail or posts welcome.

Mark. Received on Wed Nov 30 1994 - 04:22:19 CET

Original text of this message