Compiling System Stored Procedures (General)
Created at 25 JUN 1999 03:44PM
If you are attempting to compile system stored procedures you will run into a "SYS 1224 The procedure cannot be overwritten" error.
To work around this error is as follows:
1. From System Editor –> Go to FILE –> Open Record… –> SYSENV (for the table) –> SYSPROCNAMES (for the row) –> find and delete the line containing the stored procedure that you are trying to modify –> then save the record.
2. Since SYSPROCNAMES is cached you must close OpenInsight and reopen it for the changes you made to take effect.
3. Once you are back into OpenInsight you can make the changes to the system stored procedure and you are allowed to compile it.
4. It is recommended that you restore the SYSENV*SYSPROCNAMES record to it's original contents after compiling your modified stored procedure