I want to find out all the dependant objects for a particular procedure/package/function... I know it can be done thru user_dependancy but how can i find recursively. I.e suppose Proc A depends on proc B which in turn depends Proc C. Hnece to load Proc A ..i must first load proc C the proc B then proc A. How can ifind this info.