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: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 11 Sep 2006 20:38:27 +0200
Message-ID: <ee4a51$42a$1@news6.zwoll1.ov.home.nl>


Jeremy schreef:
> 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?
>
>

I believe there's a level of compilation error you can set - Daniel Morgan has posted something a while ago.
It will (default) to errors, and level 1 will generate warnings, and perhaps a level will generate what you want.

I know TOAD can - but that probably uses the same mechanism.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Mon Sep 11 2006 - 13:38:27 CDT

Original text of this message

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