How do I call a stored procedure that takes a mix of input data types? The below code is is returning the following error:
org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{? = call FND_REQUEST.SUBMIT_REQUEST(?, ?, ?, ?, ?)}]; SQL state [99999]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type
From what I can tell it's pointing to the 'return super.execute(inParams);' line where 'inParams' Map is not all the same type (ie.
String or Integer). Instead it's an Object. If that is the case how do you call a stored procedure with mixed input types such as an Integer and String?