title: Get a list of all functions and procedures in an Oracle database
body: <p>I'm comparing three Oracle schemas.</p>
  
  <p>I want to get a list of all the functions and procedures used in each database. Is this possible via a query? (preferably including a flag as to whether they compile or not)</p>
  
  <p>Ideally it would be great to have a single query with a flag that states whether the function/procedure is in each schema. But even just the first bit would be better than manually inspecting each schema.</p>