Oh my goodness..... As complicated as I had suspected especially as we have a number of rows and columns per UDT!!

Thanks for your help Barn (I think)

Take care

Lubble

Erm... I'm Fled - you're Barn... old age catching you up, deary!!!

hee hee, definitely..... sorry Fled was having one of those days!!

Hi,

A quick update on this as Oracle have recently released note ID 944783.1 which sets out how to include globals and udt's in Retro Notificaios Enhanced. Its relatively straight forward to get working though as someone previously posted you do need to have seperate checks for different udt's, (though you can do the check on groups of tables that are applied to specific types of elements e.g. unions or mileage tables).

Cheers,
Chris.