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

Hi Xavier,

thank you very much for your answer, but I donīt have any possibility to change anything on the Oracle Database.

Guntram

"Xavier Neys" <xavier.neys_at_12move.nl> schrieb im Newsbeitrag news:9n8i2d$6he$1_at_news1.xs4all.nl...
> 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
> >
> >
>
>
Received on Fri Sep 07 2001 - 04:26:33 CDT