• Post Reply Bookmark Topic Watch Topic
  • New Topic

CallableStatement Debugging  RSS feed

Posts: 26
  • 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..
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!