Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Code utilities?
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