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 |