Re: PL/SQL Code utilities?

From: <fitzjarrell_at_cox.net>
Date: 12 Sep 2006 06:38:02 -0700
Message-ID: <1158068282.112893.288860@i3g2000cwc.googlegroups.com>

DA Morgan wrote:
> Jeremy wrote:
> > Just occurred to me - is there anything available that would look at the
> > procedures/functions in a package and identify any variables that aren't
> > referenced in the code? SQL Developer perhaps?
>
> If 10g use the DBMS_WARNING built-in package documented in Morgan's
> Library at www.psoug.org.
> --
> Daniel Morgan
> Puget Sound Oracle Users Group

The OP is on 9.2.0.6, not 10g. Which is why I didn't suggest dbms_warning. And why I commented that MODULE isn't a valid column in the 9.2 implementation of the trace table plsql_trace_events.

David Fitzjarrell Received on Tue Sep 12 2006 - 08:38:02 CDT