Searches SysComments for occurances of entered keywords and returns a list of procedures that contain the keywords.
eg1) To find all procedures with 'nMyColumn' in
EXEC utl_ProcSearch 'nMyColumn'
eg2) To find all procedures with 'nMyColumn' in and 'nMyColumn2' in
EXEC utl_ProcSearch 'nMyColumn', 'nMyColumn2'
eg3) To find all procedures with temporary tables in...
EXEC utl_ProcSearch '#'
NB: Triggers also returned
Caviate: SysComments splits procedures into rows of 4000 chrs each so there is a very small chance that it could miss a procedure if the keyword spans 2 rows. As the chances of this are minimal the benfits out weigh this