How to call an Oracle procedure with Date input from Java-based webservice?

Answer 1

Without doing a thorough analysis of your code, one thing jumps out:

Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

That's not what your arguments look like

Answer 2

Have the web service bind the string to a date before passing it back. You want to do this, because it'll validate proper format and type. Binding and validating is necessary to avoid SQL injection as well.

Answer 3

Consider refactoring your code to handle dates as java.sql.Date objects instead of Strings. This will allow you to call setDate(....) instead of setString(...), and make your code cleaner.

http://java.sun.com/javase/6/docs/api/java/sql/PreparedStatement.html#setDate%28int,%20java.sql.Date%29