CODEWITHSUNDEEP
oracle-sqldeveloper
Madhav
Madhav

Reputation: 2415

How to find unused variables in proceadure or package in oracle?

How to find the UNUSED variables in oracle packages or procedures

 for example:-

 I am declaring 100 variables in procedure, among those i used 70 variables in procedure body. I want the unused variables(100-70)=30.

Upvotes: 0

Views: 1798

Answers (1)

Rahul
Rahul

Reputation: 77906

You can get that information using PL/Scope and/or compiler warnings.

ALTER SESSION SET PLSCOPE_SETTINGS='IDENTIFIERS:ALL';

(OR)

ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';

See this related Posts

Oracle PL/SQL: How to find unused variables in a long package?

How to find Unused variables in procedure,function or package

Upvotes: 1

Related Questions