Re: Support for OUT parameters in procedures

On Mon, 5 Oct 2020 at 14:59, Andrew Dunstan <andrew@dunslane.net> wrote:

>
> On 10/5/20 12:24 PM, Dave Cramer wrote:
> >
> >
> > On Mon, 5 Oct 2020 at 12:17, Steven Schlansker
> > <stevenschlansker@gmail.com <mailto:stevenschlansker@gmail.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