Re: Access 2.0 vs. Oracle stored procedure - return values

A little left of plumb wrote:
>
> In article <326F69F2.7373_at_everyday.no>, Morten Kristiansen <Morten_at_everyday.no>
> writes:
>
> > I am trying to use "pass through" to call my stored procedure (SP) in
> > Oracle. My call looks like this:
> >
> > DirektDB.Execute Q, DB_SQLPASSTHROUGH (where Q is the SP-call)
> >
> > This works fine as long as the SP only has input parameters, but when I
> > defines some output parameters, I get an error message saying:
> >
> > PLS-00363: expression '0' cannot be used as an assignment target
> >
> > It seems like I'm sending the value 0 as an parameter, and I do don't I.
> > Because I have defined a variable in the subroutine, and that parameter
> > hasn't been set to any value yet, therefore 0, right ?
> >
> > In C/C++ I should send the address of the parameter (pointer), but how
> > can I do something like that in MS-access 2.0 ?? If you got any
> > suggestions, I would be very pleased to get them.
>
> I don't believe there are any ODBC drivers that support returning values
> from stored procedures. (If there are, I hope someone will set me
> straight...)

SQL-Retriever 4 deals with return values from Stored Procedures Take a look at: http://www.vision.sco.com/brochure/sqlretriever/

> This can be done using Oracle Objects for OLE though. There's sample code in
> the OO4O help file under "Add Method Example" that'll get you started.
>
> HTH, david
  Received on Wed Nov 06 1996 - 00:00:00 CET