Add support for typeName in registerOutParameter

[thomasdewaelheyns]

In the current implementation, the OutParamArgument class inside the Call class only supports
registerOutParameter(int parameterIndex, int sqlType) throws SQLException.

For some sqlTypes, such as arrays in Oracle,
registerOutParameter (int parameterIndex, int sqlType, String typeName) throws SQLException;
should be used with a typeName: the fully-qualified name of an SQL structured type.

At the moment, there is no way to add support from outside of JDBI because the necessary classes are private, package private, or final.
Would it be possible to extend Call and OutParamArgument?

[thomasdewaelheyns]

I implemented the required changes myself to test this solution Issue2556. If the project is open to it I could open a pull request.

[hgschmie]

Hello @thomasdewaelheyns,

Thank you for opening an issue with the Jdbi project. Yes, we very much welcome contributions to the code base. Please review the https://github.com/jdbi/jdbi/blob/master/CONTRIBUTING.md document. For a change like this, an unit test would be great.

We have a number of procedure/outparameter related tests in TestCallable in the core module and in TestOutParameterAnnotation and TestPostgresRefcursorProc which should help you to see the structure of such a test.

We can run tests in the main code base with postgres, h2 and sqlite; we have very limited test support for other databases. If this is a test that needs to be validated with oracle specifically, the test would need to go into the https://github.com/jdbi/jdbi3-oracle12; in that case, please open a separate PR for that repository that contains the test.

[hgschmie]

I am happy to review and take a PR, otherwise you will have to wait until I get around to do some work with the Oracle code again.

[hgschmie]

@thomasdewaelheyns will you find time to work on this?