Blitz Report security test
Description
Run
Blitz Report security test and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |