Thread: Executing Oracle Procedure

Dear Experts,

I am calling oracle procedure from Java class on saving records,
this Oracle procedure contains many validations before updating values in some tables but its normally takes 10 - 20 seconds time for execution even if its executed directly from the database.

now the calling part of this procedure is after saving bulk number of records and in this case the procedure is not executed properly for all the records, I wonder if its because of the Queue accumulation on the procedure or is it because of the incorrect way of calling the procedure

I am writing the way I am calling the procedure

CallableStatement proc = conn.prepareCall("{ call pro_Update_table(?) }");
proc.setInt(1, 100);
proc.execute();

Note: please note that this procedure needs to be executed individually for each record, and in case if n number of records saved at once this procedure will be called n number of times

Any suggestion will be appreciated