1 Reply Latest reply: Dec 5, 2012 2:16 AM by Christian Erlinger RSS

    Database object dependencies in PL/SQL(stored procedures, Forms,Reports)

    712870
      Hi everyone,
      Did anyone interest in the topic search for dependencies between objects in the database?
      I want to see the PL/SQL code which is an appeal to a particular procedure or function or package and where and how does an object use in any PL/SQL code.
      Often do you have a need to get answers to these questions?

      I say about an object usage presentation, not about its relations only.
      Do you want to know, how opbject used?
      If it's a table - what's DML?(insert/select/...)
      If it used in a package - which procedure of package uses in?
      The object usage in an external objects - Oracle*Forms/Reports,Flat/Word files, Informatica.

      I'll want to know, if everybody interested to one.