From: | Dave Cramer <davecramer(at)postgres(dot)rocks> |
---|---|
To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | Steven Schlansker <stevenschlansker(at)gmail(dot)com>, pgsql-jdbc(at)lists(dot)postgresql(dot)org |
Subject: | Re: Support for OUT parameters in procedures |
Date: | 2020-10-05 22:21:21 |
Message-ID: | CADK3HHK0=Zr0bBrNwf5=LsujiE-03vcSj0SAoVkeRf--mZpSsA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2020-10-05 22:58:42 | Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? |
Previous Message | Tom Lane | 2020-10-05 21:42:59 | Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2020-10-06 12:46:51 | [pgjdbc/pgjdbc] 722e79: Pre release42.2.17 (#1908) |
Previous Message | Andrew Dunstan | 2020-10-05 18:59:32 | Re: Support for OUT parameters in procedures |