[MDEV-33384] ALTER PACKAGE [ BODY ] statement - Jira

XML

Word

Printable

For symmetry with ALTER FUNCTION and ALTER PROCEDURE, let's have ALTER PACKAGE and ALTER PACKAGE BODY statements.

ALTER PACKAGE package_name [package_characteristic ...]

ALTER PACKAGE BODY package_name [package_characteristic ...]

package_characteristic:

    COMMENT 'string'

  | SQL SECURITY { DEFINER | INVOKER }

We can also consider implementing adding and dropping individual routines with ALTER PACKAGE:

ALTER PACKAGE [BODY] ADD FUNCTION ...;

ALTER PACKAGE [BODY] ADD PROCEDURE ...;

ALTER PACKAGE [BODY] DROP FUNCTION ...;

ALTER PACKAGE [BODY] DROP PROCEDURE ...;

IBM DB2 has similar statements for MODULE.

relates to

MDEV-32101 CREATE PACKAGE [BODY] for sql_mode=DEFAULT

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.