Validation if database correctly executed

You could take a look here: https://blog.darwin-it.nl/2018/09/zipping-is-easy-in-javaspringsoasuite.html

I have done this several times in both 11g (where I sorted it out originally) and 12c.

Regards,
Martien

Yes you should be able to catch exceptions. I think (though I never tried) you could define java exceptions and catch those specifically.

So if you want to use you java data access objects then this is the way to go, in my opinion. However, you could write a pretty straightforward pl/sql procedure that does the delete and checks how many rows are affected. See for instance: https://stackoverflow.com/questions/861983/number-of-rows-affected-by-an-update-in-pl-sql#862019

So you could do something like

procedure delete_emps(p_status in varchar, p_cnt_deleted out number)

is

begin

  delete from

UPDATE employees

    SET status = 'fired'

    WHERE name like '%Bloggs';

    i := sql%rowcount;

3741383 wrote:hi thankyou for you answer, so i have to using Sping service component to be able create a validation for BPEL? never using it before, and thankyou for the further explanation sir Martien van den Akker could i use exception catch? for this situation?