I know this can be done but havent had success goggling for this sort of query

Thanks!
bob

--
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."
--
http://www.freelists.org/webpage/oracle-l