Tutorial by Examples

Typically, you will want to create your SimpleJdbcCalls in a Service. This example assumes your procedure has a single output parameter that is a cursor; you will need to adjust your declareParameters to match your procedure. @Service public class MyService() { @Autowired private DataSour...

There are a number of issues with Oracle. Here's how to resolve them. Assuming your procedure output parameter is ref cursor, you will get this exception. java.sql.SQLException: Invalid column type: 2012 So change Types.REF_CURSOR to OracleTypes.CURSOR in simpleJdbcCall.declareParameters() ...