Blitz Report security test

Description
with function xxen_update_test_func(p_id in number, p_value in varchar2) return varchar2 is
l_records_updated number;
--pragma autonomous_transactio;
begin
  update xxen_update_test xut set xut.value=p_value where xut.id=p_id;
  l_records_updated:=sql%rowcount;
  commit;
  return 'successfully updated '||l_records_updated||' records.';
end;
select
xxen_update_test_func(1,'now yet another new value') test_result
from
dual
Download
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: