Re: Support for OUT parameters in procedures

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Support for OUT parameters in procedures
Дата
Msg-id CADK3HHK0=Zr0bBrNwf5=LsujiE-03vcSj0SAoVkeRf--mZpSsA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Support for OUT parameters in procedures  (Andrew Dunstan <andrew@dunslane.net>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Support for OUT parameters in procedures
Следующее
От: Dave Cramer
Дата:
Сообщение: [pgjdbc/pgjdbc] 722e79: Pre release42.2.17 (#1908)