The optional semicolon and integer number after the name of the procedure in the create procedure and execute statements allow you to group procedures of the same name so that they can be dropped together with a single drop procedure statement.
Procedures used in the same application are often grouped this way. For example, you might create a series of procedures called orders;1, orders;2, and so on. The following statement drops the entire group:
drop proc orders
Once procedures have been grouped by appending a semicolon and number to their names, they cannot be dropped individually. For example, the following statement is not allowed:
drop proc orders;2
To run Adaptive Server in the evaluated configuration, you must prohibit grouping of procedures. This ensures that every stored procedure has a unique object identifier and can be dropped individually. To disallow procedure grouping, a System Security Officer must reset the allow procedure grouping configuration parameter. See Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide: Volume 1.
