you beauty!!! \o/
I used the execute immediate and I also took the driving list from user_tables (as I only wanted tables in my schema) and it works a treat. I realise there are probable better ways to do this but I wanted to learn a little PLSQL.....and I did! Thanks again.

*chrispy adds ales to christmas card list *