File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes CallableStatement Debugging Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "CallableStatement Debugging" Watch "CallableStatement Debugging" New topic
Author

CallableStatement Debugging

Andrew Sweeney
Greenhorn

Joined: Jan 11, 2002
Posts: 26
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CallableStatement Debugging
 
Similar Threads
Handling session timeout
How to use IN OUT parameter
Passing NULL to the database
Callable statement ...?
double value changes