Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Code utilities?

Re: PL/SQL Code utilities?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 12 Sep 2006 06:49:59 -0700
Message-ID: <1158068998.469839@bubbleator.drizzle.com>


fitzjarrell_at_cox.net wrote:
> 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

Didn't see that: Thanks.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Tue Sep 12 2006 - 08:49:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US