Re: Support for OUT parameters in procedures

On Mon, 5 Oct 2020 at 14:59, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:

>
> On 10/5/20 12:24 PM, Dave Cramer wrote:
> >
> >
> > On Mon, 5 Oct 2020 at 12:17, Steven Schlansker
> > <stevenschlansker(at)gmail(dot)com <mailto:stevenschlansker(at)gmail(dot)com>> wrote:
> >
> > Jdbi got a feature request for such parameters a while back:
> > https://github.com/jdbi/jdbi/issues/1606
> >
> > The user uses Oracle which I don't really care to install. When I
> > tried to implement the feature using Postgres,
> > I found the driver support too lacking to proceed.
> >
> > So there's some interest out there in making it work, and I can
> > volunteer to at least smoke test it with my test cases...
> >
> >
> > Sure, lets see how broken it is right now.
> >
> >
> >
>
> We're working on it. It's a bit tricky, but we need to get it working,
> for sure. The main thing is that the driver needs to send some type
> other than VOID for the OUT param. Minimally that can be UNKNOWN, but it
> should probably reflect the type set in registerOutParameter().
>
> I would think we run into the normal issues with things like timestamps
and dates with and without time zones

Thanks,

Dave Cramer
www.postgres.rocks