micronaut-data icon indicating copy to clipboard operation
micronaut-data copied to clipboard

Add support for easy invoking and binding the result of a stored procedure

Open graemerocher opened this issue 4 years ago • 1 comments

Feature description

Currently Micronaut Data JDBC has no simple way to invoke stored procedures

graemerocher avatar Oct 08 '21 06:10 graemerocher

Agree it would be great as for example, the Oracle database 19c has tons of already existing stored procedures or functions available through so-called PL/SQL packages: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/

The JDBC API has a way to retrieve information on existing stored procedures, stored functions, packages or catalogs containing these as well as all the information about returned values and parameters. Look for https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getFunctionColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String) for instance

loiclefevre avatar Jan 27 '22 17:01 loiclefevre