Re: How can I read Variables returned from a Stored Procedure

Hi Guntram,

I believe you can use parameters if you work with ADO but I never tried that as I have always stuck to pass-through queries and left Oracle do all the work. So here is how I solved this kind of problem : (this may be more work than you expected)

. Create a package with a procedure which calls your ...put_request() procedure and stores the OUT params in package variables
. Create one function for each parameter in the same package. Each function should simply do a return VARx;
. Use a pass-through query to call your package procedure instead of the current one
. Use a second pass-through query that does a select pkg.f1, pkg.f2,... from dual; to retrieve the results

As an extra thought, do not forget to use the pragmas restrict WNDS in the package definition to let Oracle allow you to select the functions. This is just to let Oracle know your functions will not update the database.

Sorry I can't remember the syntax by heart. That was a few months ago and a few hundred kilometers away. I haven't any Access nor any Oracle DB available as I am sitting home between projects.

Feel free to ask for more info if you need to.

HTH,

--
Today, Tomorrow, Together
The DOC
(The Dutch Oracle Company)

Xavier.

"Guntram Ulrich" <ulrich_at_vivai.com> wrote in message news:3b97b0be_1_at_news.arcor-ip.de...


> Hi there,

>

> I have the following Stored Procedure running on an Oracle Database

>

> adb_access.adb$fu_put_request(0819,'4915112600028',v_xml,:rc,:text);

>

> Can anybody tell me how I can read the returned Variables v_xml, rc and text

> in a Pass Through Query in Access?

>

> Thanks for answers,

> Guntram

>

>