If I take away the last two registerOutParameter calls I get there error: java.sql.SQLException: ORA-00900: invalid SQL statement
After searching on the internet I don't see complete consistency on how to do this - I guess one question is in terms of the output -- In theory -- since I am going to get one resultSet with 2 columns of values what do I need to 'registerOutParameter' all 3 or just the resultSet or what?
Hello, The binding error is because of line 3 and 4. There no Parameters numbered 3 and 4 as we can make out from the CallableStatement you are preparing. You get the resultset and then iterate over it to retrieve the VARCHAR values inside it.
You also need to change
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: calling stored proc. w/ resultset return?