Return
-
Title
A loaded procedure into the Editor cannot be edited. -
Description
Why can I not edit a procedure when I loaded it from the Schema Browser into the editor?
-
Resolution
1. Check with your DBA to make sure you have rights to alter procedures.
2. If rights are verified, check to make sure Team Coding is not enabled by going to Utilities | Team Coding | Team Coding Status. Is there a green check next to "Team Coding Enabled?" If there is, click on "Setting" and uncheck "Enable Team Coding."
3. If Team Coding is required to be used, you must set up a Code Control Group to allow editing of any store procedure. Please refer to the Help | Content in Toad for info on Team Coding and Code Control Groups.