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, perform one of these steps:
    • To copy the base stored procedure into the work space on the form, click Copy Procedure.
    • To drop the existing extgen_ procedure, click Drop Extgen.
    • To open the existing extgen_ procedure, click Open Extgen.
    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.
    Note: The Drop Extgen and Open Extgen buttons are enabled when a valid extgen_ is in the stored procedure name.
  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.