This pull request improves SimpleJdbcCall when targeting the Oracle database as follows:
-
Improve support of Oracle PL/SQL packages for Spring JDBC: Oracle database stored procedures or functions can be overloaded. Hence, the possibility to find several matching signatures by just using the schema name, catalog name and procedure/function name is real. This PR adds columns data type checking to properly find the desired stored procedure or function.
-
Ease debugging for DBMS_ packages if SYS not specified: explicitly checks the catalog name being used and if starting with DBMS_% and no matching signature was found then report in the log it could be useful to use SYS as the schema name