SQL & PL/SQL

Hi All

I am trying to delete few rows from a table (In fact, there are set of tables - these table names are stored in another table, and the idea is to go through all of them and delete all rows). I am trying to put it simple here.

I am using execute immediate to delete them. When I ran the following procedure - it said `success' (and it was).

begin
  for idx in (select table_name
                   from MY_DEBUG_TABLES)
  loop
     execute immediate ('delete from '||idx.table_name)
  end loop;
end;

When I checked the table, it had no rows. Good. But, I wonder, is it possible to find the number of rows are deleted?

I put execute immediate ('dbms_output(SQL%ROWCOUNT)') after first execute immediate. It errored out.

Is there a way to find the rows deleted?

I am using Oracle 9i / Sun OS 5.2

Thanks in advance
Guru