VisibilityUnlisted - anyone with the share link can access
DescriptionIt is unfortunately how things work. Your block could be deleting 20 rows, then updating 10, etc. SQL%ROWCOUNT always returns 1 after successful execution of a PL/SQL block run via execute immediate. You might consider calling SQL%ROWCOUNT _inside_ the dynamic block and then return that value and use it.
ContributorSteven Feuerstein
CreatedTuesday July 14, 2020
Statement1
begin
execute immediate 'begin null; end;';
dbms_output.put_line (sql%rowcount);
end;