• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to call StoredProcedure with mixed input data types?

 
john zzffee
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic