HI,
Is there a way to declare a dymamic record in PL/SQL. I wolud like to build a framework that would insert data from several (23 different)tables.

I can have the column list with the ALL_TAB_COLUMN table and I would like to create a record based on these columns. This way, with EXECUTE IMMEDIATE, I would be able to only change the source and target table and still using the same insert procedure instead of creating 23 different procedure that does the same thing.

Thank you for your help,
Christian Cote