Compiling System Stored Procedures (General) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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