ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A7207F2E6A0045F6E053B46B6358934EY 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 US Blitz Report security test