Delete Batch commit deletes datasheet record

Due to business needs, the business table data needs to be deleted, so learn from the Eygle way, as follows:

Create or replace procedure Del_datpayment
(
P_tablename in varchar2,--table name
,--conditions of P_condition in VARCHAR2
P_count in varchar2--the number of articles submitted per batch
)
As
pragma autonomous_transaction;
N_delete number:=0;
Begin
While 1=1 loop
EXECUTE IMMEDIATE
' Delete from ' | | p_tablename| | ' WHERE ' | | p_condition| | ' and rownum <=: Rn '
USING P_count;
If Sql%notfound Then
Exit
Else
N_delete:=n_delete + sql%rowcount;
End If;
Commit
End Loop;
Commit
Dbms_output. Put_Line (' finished! ');
Dbms_output. Put_Line (' Totally ' | | To_char (n_delete) | | | ' records deleted! ');
End