• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CallableStatement Debugging

 
Andrew Sweeney
Greenhorn
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..
Andrew
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic