X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F21C19DC807 for ; Thu, 2 Feb 2006 02:31:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39576-09 for ; Thu, 2 Feb 2006 02:31:23 -0400 (AST) X-Greylist: delayed 00:06:40.053121 by SQLgrey- Received: from sitara.inventum.cc (unknown [69.20.4.27]) by postgresql.org (Postfix) with SMTP id 16C7B9DC81E for ; Thu, 2 Feb 2006 02:31:19 -0400 (AST) Received: (qmail 17585 invoked from network); 2 Feb 2006 06:41:54 -0000 Received: from unknown (HELO ?192.168.1.2?) (127.0.0.1) by 127.0.0.1 with SMTP; 2 Feb 2006 06:41:54 -0000 Message-ID: <43E1A5A0.1000401@inventum.cc> Date: Thu, 02 Feb 2006 11:54:32 +0530 From: Padam J Singh Organization: Inventum Technologies Pvt Ltd User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Function Dependency Content-Type: multipart/mixed; boundary="------------030008020104050005080209" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200602/16 X-Sequence-Number: 24026 This is a multi-part message in MIME format. --------------030008020104050005080209 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hello,

I am maintaining an application that has over 400 procedures and functions written in plsql, and around 100 tables.
I want to generate a function dependency chart to depict the following:

1. Inter function/procedure dependencies
2. function-tables dependencies
3. function-sequences depencies

Is there a standard method of doing this?

Thanks in advance,
Padam.
--------------030008020104050005080209 Content-Type: text/x-vcard; charset=utf-8; name="padam.singh.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="padam.singh.vcf" begin:vcard fn:Padam Singh n:Singh;Padam org:Inventum Technologies Pvt. Ltd.;Engineering adr:SDA Commercial Complex;;C-17;New Delhi;Delhi;110016;India email;internet:padam.singh@inventum.cc title:Sr. Solutions Architect tel;work:+91-11-55650222 tel;fax:+91-11-26518800 tel;cell:+91-9810146640 x-mozilla-html:TRUE url:http://www.inventum.cc version:2.1 end:vcard --------------030008020104050005080209--