Unified audit does not log updates executed inside forall
Hi
Oracle 19.16
SQL> select * from audit_unified_policies where policy_name = 'OKIS_POLICY' and object_name = 'MENETLUSED' order by policy_name, object_schema, object_name;
-- This update will be logged by the policy
UPDATE Menetlused SET LoppKP = LoppKP WHERE iD = 6168856;
commit;
-- This will not be logged with the same policy
set serveroutput on;
DECLARE
TYPE c1 IS RECORD (
id NUMBER
);
TYPE t1 IS TABLE OF c1;
t t1;
BEGIN
select 6168857 as id
BULK COLLECT INTO t
FROM dual;
-- Uuendame menetluste küljes andmed
FORALL I IN INDICES OF t
UPDATE Menetlused SET loppkp = loppkp WHERE ID = t(I).id;
dbms_output.put_line('Updated ' || SQL%ROWCOUNT || ' table row.');
commit;
END;
/
0