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: rrkear <triple.r.kear_at_gmail.com>
Date: 12 Sep 2006 18:39:20 -0700
Message-ID: <1158111560.116952.257480@i42g2000cwa.googlegroups.com>


hi!
  using plsql developer 7 you can check if the variable have been used in the code, if you compile a procedure on it, it will display those variables that are not used.

regards,
rhani

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?
>
>
> --
> jeremy
>
> ============================================================
> ENVIRONMENT:
> Oracle 9iR2 / Oracle HTTP Server / mod_plsql / Solaris 8
> ============================================================
Received on Tue Sep 12 2006 - 20:39:20 CDT

Original text of this message

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