From oracle-l-bounce@freelists.org Wed Jun 30 16:14:07 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5ULDgi06915 for ; Wed, 30 Jun 2004 16:13:52 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5ULDW606904 for ; Wed, 30 Jun 2004 16:13:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5246172C88B; Wed, 30 Jun 2004 15:55:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06661-48; Wed, 30 Jun 2004 15:55:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A451372C18A; Wed, 30 Jun 2004 15:55:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 30 Jun 2004 15:54:33 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2285D72CB94 for ; Wed, 30 Jun 2004 15:54:33 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06638-28 for ; Wed, 30 Jun 2004 15:54:33 -0500 (EST) Received: from relay01.uchicago.edu (relay01.uchicago.edu [128.135.12.136]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C859872CB1A for ; Wed, 30 Jun 2004 15:54:32 -0500 (EST) Received: from AIS-PC2.uchicago.edu (ais-pc2.uchicago.edu [128.135.15.112]) by relay01.uchicago.edu (8.12.10/8.12.9) with ESMTP id i5ULHG0O012930 for ; Wed, 30 Jun 2004 16:17:16 -0500 (CDT) Message-Id: <5.2.0.9.2.20040630161114.02fb6a90@nsit-imap.uchicago.edu> X-Sender: mschmitt@nsit-imap.uchicago.edu X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Wed, 30 Jun 2004 16:17:15 -0500 To: oracle-l@freelists.org From: Mike Schmitt Subject: Procedures within Packages In-Reply-To: <75DFF91B31A1284992092BDB70C92324035E6123@ftwp45ns.br-inc.n et> Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4116 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mschmitt@uchicago.edu Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi all, dba_dependencies tells us which tables that a package touches. However, a package might consist of 20 separate procedures. We have been asked to find out what tables each procedures of a package reference. for example: test.proc1 references tables: emp, department, region test.proc2 references tables: emp test.proc3 references tables: region, department Thanks for the help ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------