How to Disable NonEditionable property

[Pugazh]

Hi,

The stored procedure is opened with "NONEDITIONABLE" property when we edit/open the procedure in PL/SQL developer window. How to disable it or open procedure without this keyword?

Regards,
Pugazh

 

[Marco Kalter]

I assume this procedure was created as noneditonable? Right-click on the procedure, select “Properties‿, and check if the “EDITIONABLE‿ property is set to “N‿.

 

[Pugazh]

All the procedures are having EDITIONABLE property as N. How to change it as Y for all objects? This is set as N when we compile new procedure through PL/SQL developer

 

[Marco Kalter]

You can execute an "alter procedure editionable;" command for each procedure where the editionable property is N.

If you omit the editionable/noneditionable clause when creating the procedure, it will be editionable.