I’d like to call this function using Spring boot and be able to display the data that is stored in an object. I’ve tried several times but without any progress or results.

BookingDao:

SimpleJdbcCall jdbcCall = new SimpleJdbcCall(jdbcTemplate)
                .withCatalogName("package")
                .withFunctionName("function")
                .withoutProcedureColumnMetaDataAccess()
                .declareParameters(new SqlParameter[]{
                    new SqlParameter("",Types.VARCHAR),
                    (....)
                }
MapSqlParameterSource in = new MapSqlParameterSource()
                    .addValue("", param)
                    ...;
Map<String, Object> rs = jdbcCall.execute(in);

SQL Query:

select package.function (:param1,:param2,:param3,:param4,:param5,:param6,:param7) from dual

A screenshot of what the query returns:

enter image description here

I don’t know how to face this challenge, thank you for the help…

If you need more details of the doubt or challenge, tell me and I will modify the data provided.