CallableStatement Debugging
Andrew Sweeney
Greenhorn
Posts: 26
posted 15 years ago
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
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. |