16
Procedure '%.*s' group number 1 already exists in the database. Choose another procedure name or procedure number.
Procedures that are meant to be used together in an application can be created with the same name and different version numbers, using an option of the create procedure statement. For example, procedures used with the application ticket can be named ticketproc;1, ticketproc;2, and so on. The numbers are referred to as the group numbers of the procedure.
Error 2729 occurs when you attempt to:
Create a procedure without specifying any group number, and a procedure by that name already exists. Adaptive Server assumes that you want to create a procedure in the same group as the existing procedure, but the command fails since no group number is specified, and the default group number 1 already exists.
Re-use an existing group number when creating procedures with the same name.
To resolve the problem, do one of the following:
Supply a different procedure name
or
Supply the same procedure name, but include a unique procedure group number. For example:
1> create procedure myproc;2 ...
This results in two procedures with the same name and group numbers 1 and 2, respectively.
All versions
