Re: Support for OUT parameters in procedures

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().

cheers

andrew

--
Andrew Dunstan
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company