To call Oracle's stored procedure using only simple JDBC in Java we could do something like this:
con.prepareCall("{ call ? = my_procedure(?) }");
callStm.registerOutParameter(1, Types.INTEGER);
callStm.setInt(2, -100);
callStm.execute()
I want to know is it somehow possible to call more then one procedure inside one prepareCall statement? For example:
con.prepareCall("{ call prepare_proc(); ? = my_procedure(?) }");
Of course it is not valid, but how to fix it and call two or more procedures in one shot?