When I run this I get: java.sql.SQLException: ORA-01006: bind variable does not exist.
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.