Flo
4/17/2018 - 5:57 AM

Delete ITOS by param_name

declare
    p_itos_name   varchar2 (255) := 'TRUSTSTORE_URL';
    p_object number := 503;
begin
    delete from u_functions_2_itos
          where itos = (select id
                          from if_transaction_objects_setting
                         where param_name = p_itos_name and object = p_object);

    delete from if_transaction_objects_setting
          where param_name = p_itos_name and object = p_object;
end;