爱华网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;
