Using this procedure, I generated the 'Create Public Synonym ....' statements for all the tables and then used them individually to generate the synonyms - without using the 'Execute Immediate..'. My work is done - in a indirect way - but if anyone can think of anything that we may have missed here, I would surely like to know about it.

Thanks for all your help.
Shiva.