Re: Support for OUT parameters in procedures - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Support for OUT parameters in procedures
Date
Msg-id CADK3HHK0=Zr0bBrNwf5=LsujiE-03vcSj0SAoVkeRf--mZpSsA@mail.gmail.com
Whole thread Raw
In response to Re: Support for OUT parameters in procedures  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-jdbc


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

pgsql-jdbc by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Support for OUT parameters in procedures
Next
From: Dave Cramer
Date:
Subject: [pgjdbc/pgjdbc] 722e79: Pre release42.2.17 (#1908)