oracle - Java JDBC exec procedure with sql statement -

i need execute sql code:

exec procedure(param, param, param, param)  select * bla_bla_table;  commit; 

and resultlist query.

i tried this:

callablestatement stmt = connection.preparecall("{call procedure(param,param,param,param)}"); stmt.execute(); 

how can insert sql statement select * bla_bla_table; here before commit resultset. tried lot of ways that... nothing helps.

did try this?

connection.setautocommit(false); // disable auto commit callablestatement stmt = connection.preparecall("{call procedure(param,param,param,param)}"); stmt.execute();  statement stmt2 = connection.createstatement(); resultset rs = stmt2.executequery("select * bla_bla_table"); // result set query  connection.commit();