wood burning stoves 2.0*
The moose likes Spring and the fly likes How to call StoredProcedure with mixed input data types? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "How to call StoredProcedure with mixed input data types?" Watch "How to call StoredProcedure with mixed input data types?" New topic
Author

How to call StoredProcedure with mixed input data types?

john zzffee
Greenhorn

Joined: Apr 01, 2010
Posts: 1
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?

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to call StoredProcedure with mixed input data types?