This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CallableStatement Debugging

Andrew Sweeney
Posts: 26
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
Odd problem here. I am calling a stored procedure on Oracle 8.1.7. It takes an IN param of type NUMBER(36), and has an OUT param of VARCHAR2. When I execute the following code, I am greeted with an SQL Exception stating:
'wrong number or types of arguments in call to GET_RESTRICTIONS.'
Well, I know that it is hitting the correct procedure, but I can't for the life of me figure out why it has a difficulty with the type. I'm using setDouble( value ) to place the value, and registerOutParameter( 2, OraclyTypes.VARCHAR) for the OUT. Any ideas? Appreciation in advance..
I agree. Here's the link:
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic