*
The moose likes JDBC and the fly likes When is the Exception thrown in case of Oracle driver when calling a stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "When is the Exception thrown in case of Oracle driver when calling a stored procedure" Watch "When is the Exception thrown in case of Oracle driver when calling a stored procedure" New topic
Author

When is the Exception thrown in case of Oracle driver when calling a stored procedure

Chad Ford
Greenhorn

Joined: Aug 16, 2003
Posts: 1
Hello all, For executing a stored procedure one does something like the following:

CallableStatement cStmt = Connection.prepareCall(sql);
cStmt.registerOutParameter(parameterIndex,sqlType);
cStmt.setString("blah");
cStmt.execute()
result = cStmt.getString(index);
Now according to javadoc the Exception can be thrown at either when doing the Connection.prepareCall(..) or when doing the CallableStatement.execute() and its supposed to be depenedent on the driver.
I am using the Oracle driver from classes111.zip but I can't find in the documentation where its supposed to throw the Exception? I think it throws it when one does the CallableStatement.execute() and not when one does the Connection.prepareCall()
Can anyone verify this or point to to some document?
thanks
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: When is the Exception thrown in case of Oracle driver when calling a stored procedure
 
Similar Threads
Clobs, Stored procedures and Oracle 8i
PROCEDURE x does not exist...
JDBC Sybase Stored Procedure Exception
java.lang.ClassCastException
Calling Oracle stored procedures in JRun container