About Creation of Extended Stored Procedures

Nearly all the stored procedures in the databases have a special check embedded in the code near the beginning of the procedure. This check looks for an extension to the stored procedure, named extgen_baseProcedureName, where baseProcedureName is the name of the stored procedure being extended. If this stored procedure extension exists, then it is called when the stored procedure is invoked.

Within the system, there is a protected table that contains a select list of stored procedures that have this extgen_ capability. System users cannot modify this table in any way. This table simply provides a list of stored procedures that can be extended using the Edit Stored Procedure form.

The primary purpose of this table and the Edit Stored Procedure form is to allow developers working in a cloud environment to create some of these extgen_ stored procedures. A typical use would be to modify the data going into reports.

Because this functionality is designed primarily for use in a cloud environment, special security measures apply to the extended stored procedures. Developers cannot perform these tasks:

  • Alter the table that contains the list of valid extendable stored procedures
  • Create anything other than an extgen_ stored procedure
  • Create an extgen_ stored procedure to any stored procedure other than those included in the designated table
  • Embed calls to dynamic SQL in the procedure code
  • Include calls to databases outside the current database in the procedure code

Other restrictions also apply.