OK, got it worked.
Seems that there are some thoubles with calling Oracle9i stored procedure, which will return a CURSOR.
Is there a other way of workaround ? Here is a piece of my code:
Code:
CallableStatement cstmt = connection.prepareCall(
"{call FIRSTPKG.second_procedure(?, ?)}");
cstmt.setString(1, "here");
cstmt.registerOutParameter(2, OracleTypes.CURSOR);
cstmt.execute();
gloeglm wrote:
Get the JDBC connection by calling session.connection() and call your stored procedure like you allways do with SQL.
Login
FAQ
Search
