Blitz Report security test

Description

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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