Forum Stats

  • 3,760,130 Users
  • 2,251,648 Discussions
  • 7,870,992 Comments

Discussions

Validation if database correctly executed

3741383
3741383 Member Posts: 20
edited Feb 26, 2020 10:33AM in Business Process Management Suite

hello good day everyone,

So I have a java code like this

MessageExceptionDTO result = obatService.ObatDelete(obat);

if (result.isSuccess()) {

entity = ShareMethod.getResponse(HttpStatus.OK, result.getMessage());

} else

entity = ShareMethod.getResponse(HttpStatus.NOT_MODIFIED, result.getMessage());

So that's for success code if the application successfully deletes from the database, is there any way to make this in BPEL?

3741383

Best Answer

  • Martien van den Akker
    Martien van den Akker Member Posts: 2,776 Bronze Crown
    edited Sep 13, 2018 2:33AM Accepted Answer

    Sorry, the editor got stuck some how...

    I thought of something like

    procedure delete_emps(p_status in varchar, p_cnt_deleted out number)isbegin   delete from  employees   WHERE status = p_status;    p_cnt_deleted    := sql%rowcount;end;

    (But then put in a package)

    You can call this procedure using the database adapter.

    Regards,

    Martien

Answers

This discussion has been closed.