[Feature Request]: Stored Procedure menus

[cwolcott]

Would you consider a couple of new features for stored procedures?

OS: MacOS Catalina 10.15.7 Software: SQLPro Oracle Version 2022.31 (Build 511.5) Connection: Oracle 19

• If a stored procedure is INVALID mark with a red 'x' icon.

  You can determine if stored procedures are invalid if the status is 'INVALID' select * from user_objects where object_type = 'PROCEDURE';

• Add a Compile menu item Should be able to compile a stored procedure with ALTER PROCEDURE spName COMPILE; After the compile check STATUS and update icon.

• Instead of showing the in/out variables as small text, could they be listed like table/view columns?

• After dropping a stored procedure, check the status of the other store procedures and update icon if INVALID. Stored procedures can call another stored procedure which would become invalid if a dependent SP is dropped.

• The menu item Script as - Create To should begin with CREATE OR REPLACE PROCEDURE instead of just CREATE PROCEDURE

[hankinsoft]

Q: This is relevant to both procedures and functions correct?

This rest of this comment is for my own sake.

• If a stored procedure is INVALID mark with a red 'x' icon.
• Add a Compile menu item
• Instead of showing the in/out variables as small text, could they be listed like table/view columns?
• After dropping a stored procedure, check the status of the other store procedures and update icon if INVALID. Stored procedures can call another stored procedure which would become invalid if a dependent SP is dropped.
• ~~The menu item Script as - Create To should begin with CREATE OR REPLACE PROCEDURE instead of just CREATE PROCEDURE~~