Hi all, We are using JBoss 4.0.5 and Oracle 9i. and have exactly similar scenario where we are getting the connection object through Data source lookup and executing a stored procedure have ref cursor. We are also getting following error:- java.lang.ClassCastException: $Proxy2 Code snippet: boolean success = stmt.execute(); ResultSet rsRawData = ((OracleCallableStatement)stmt).getCursor(7); OR boolean success = stmt.execute(); ResultSet rsRawData = ((ResultSet)stmt).getCursor(7); But if we don't use JBoss datasource and create a connection using DriverManager then it works perfectly fine. Any assistance on this will be helpful. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4077481#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...