Re: MSAccess into Oracle's procedures, and procedure variables

From: Mark Hammond <MHammond_at_cmutual.com.au>
Date: Wed, 14 Dec 1994 01:53:23 GMT
Message-ID: <D0s2L0.M4v_at_cmutual.com.au>

In article <iano.9.003A7BFF_at_SunBelt.Net>, iano_at_SunBelt.Net (Ian Ornstein) says:
>
>In article <D029D8.KMJ_at_cmutual.com.au> MHammond_at_cmutual.com.au (Mark Hammond) writes:
>>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.
>How are you calling this procedure, Mark?
>Post your code, it will help with suggestions.
>Are you using a PASSTHRU_QUERY?
>I'm going to need to do this too.

Thanks.

We are using an SQL passthrough query. It looks like: BEGIN

	DECLARE outvar
	proc_name( 'input param', outvar )

END Our Oracle guru's here tell me that "outvar" has been created on the _server_, and correctly filled in. What I need to know is how to get "outvar"'s contents back to the client.

The stock solution seems to be "modify the procedure to write the results back to a temp table", but this is a nasty solution.

Thanks...

Mark.          Received on Wed Dec 14 1994 - 02:53:23 CET