What Is a Stored Procedure?

A stored procedure is an executable BASIC+ programming module, written by you, or provided with OpenInsight, stored as an entity in the repository, and not linked to a specific window. The stored procedures that you write are stored as rows in the SYSPROCS table in the repository. The stored procedures provided by OpenInsight for Workgroups in executable form are referred to as system stored procedures or SSPs. Stored procedures include functions and subroutines. Stored procedures can be called from procedural and non-procedural event handlers. System stored procedures belong to the SYSPROG application and are automatically inherited by all applications. Developer stored procedures are stored procedures that you write specifically for your application.

Stored procedures move your application forward when it comes to meeting requirements for custom processing. Using the BASIC+ language, full-scale custom programs can be created, that are easily driven from the user interface.