sql%rowcount必须在commit或者rollback之前

create or replace procedure t_ts(TABLE_NAME VARCHAR2) AS

  n     number;

  V_SQL VARCHAR2(500);

BEGIN

  V_SQL := Q'[delete from ]' || TABLE_NAME || Q'[]';

  EXECUTE IMMEDIATE V_SQL;

  n := sql%rowcount;

  COMMIT;

  dbms_output.put_line(n);

end t_ts;

create or replace procedure t_ts(TABLE_NAME VARCHAR2) AS

  n     number;

  V_SQL VARCHAR2(500);

BEGIN

  V_SQL := Q'[delete from ]' || TABLE_NAME || Q'[]';

  EXECUTE IMMEDIATE V_SQL;

    COMMIT;

  n := sql%rowcount;

  dbms_output.put_line(n);

end t_ts;