Hello Danny,

I think you need to add some quotes around text field:

example:
instruction :=' insert into table_sum values (' || table_name || ',' || num_rows || ',' || num_blocks || ',' || to_char(sysdate,'yyyy/mm/dd') || ')' ;

Becomes:

instruction :=' insert into table_sum values (''' || table_name || ''',' || num_rows || ',' || num_blocks || ',''' || to_char(sysdate,'yyyy/mm/dd') || ''')' ;

In fact you need to give varchar2 parameter and if you forget '' characters (double ') Oracle thinks that it is a column name!!!!

I don't understand why you don't have any error. Are you sure you don't catch exception?

Have a nice day,
Best Regards,
Stephane.