Creating an Extended Stored Procedure

To create an extended stored procedure:

  1. With the Edit Stored Procedure form open, select from the list the base Stored Procedure you want to extend.
  2. Optionally, to copy the base stored procedure into the work space on the form, click Copy Procedure.
    Note:  To remove any code in the base stored procedure  that might exist before the code that calls the extgen_ stored procedure, select the Remove To Extgen option before copying the procedure.
  3. Write or modify your code in the editable text work space.
    Note: The stored procedure extension code must begin with a CREATE PROCEDURE statement.
  4. When finished, click Submit.
Related topics