Re: SQL Function call tree

From: DW <david.wilkie_at_gecapital.com>
Date: 13 Feb 2002 01:11:31 -0800
Message-ID: <92b9b544.0202130111.62fcc115@posting.google.com>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3c69248b$0$233$ed9e5944_at_reading.news.pipex.net>...
> if you mean a PL/SQL package what would such a utility give you that DESC
> doesn't.
>

It would give you an idea of what functions call what. Here is an example of the output from MetreTree (a UNIX utility which does this for C progs) ...

         main
          +---print_error
          |    +---print_warning
          |    |    `---strip_path
          |    +---strip_path
          |    `---sqlglm
          +---print_warning
               +---strip_path
               `---sqlglm

As you can see from this, "main" calls two functions - "print_error" & "print_warning". Each of these functions are also detailed into what they call. This would be very useful when trying to identify the entry points into a package.

Is this any clearer ?

Regards,
David. Received on Wed Feb 13 2002 - 03:11:31 CST