I figured out how to do it.. For posterity I'll post it here...
| cst = connection.prepareCall("{call request_list.get_default_request_list
(?,?,?)}");
| cst.setInt(1, 1);
| cst.setInt(2, 1);
| cst.registerOutParameter(3, OracleTypes.CURSOR);
| cst.execute();
|
| rs = (ResultSet) cst.getObject(3);
|
Note that using getCursor doesn't work BUT getObject does provided I tell the output
parameter it's a oracle cursor.
Go figure - the one thing I didn't try was the way to fix it..
The reason for this is that JBoss called statements are implemented via a
WrappedCallableStatement (a JBoss object) and that can't be cast to the
OracleCallableStatement (which makes sense after I thought about it a bit). However,
you can register the output parameter as an oracle type and then cast *that* to the
result set.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839431#3839431
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839431
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
