Test Stored procedure call with different types of IN/OUT parameters - Postgres

[souravroy]

We are using SimpleJdbcCall to execute stored procedure or function. As per the documentation:

The SimpleJdbcCall class uses metadata in the database to look up names of in and out parameters so that you do not have to explicitly declare them. You can declare parameters if you prefer to do that or if you have parameters (such as ARRAY or STRUCT) that do not have an automatic mapping to a Java class.
https://docs.spring.io/spring-framework/reference/data-access/jdbc/simple.html#:~:text=The%20SimpleJdbcCall%20class%20uses%20metadata,mapping%20to%20a%20Java%20class

In our code we are not declaring parameters, hence it may be a good idea to test stored procedure/function call with different types of in/out parameters.