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

From Andrew Dunstan
Subject Re: Support for OUT parameters in procedures
Date
Msg-id ce81db76-8e86-5381-dd95-49381a4373e8@dunslane.net
Whole thread Raw
In response to Re: Support for OUT parameters in procedures  (Dave Cramer <davecramer@postgres.rocks>)
Responses Re: Support for OUT parameters in procedures  (Dave Cramer <davecramer@postgres.rocks>)
List pgsql-jdbc
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().


cheers


andrew


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




pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Support for OUT parameters in procedures
Next
From: Dave Cramer
Date:
Subject: Re: Support for OUT parameters in procedures