aspose file tools*
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
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
 
 
subject: When is the Exception thrown in case of Oracle driver when calling a stored procedure