The term stored procedure is a general term for any routine for which you create a stored procedure object in your data dictionary. Advantage supports stored procedures in two distinct forms: SQL stored procedures and Advantage Extended Procedures. Advantage Extended Procedures are often referred to as AEPs for short.
AEPs are compiled modules in the form of Windows DLLs, Linux shared object (so) libraries, .NET managed assemblies, or COM objects. All AEPs, regardless of how they are compiled, share a number of specific characteristics, including when they are loaded, how they are initialized, and what housekeeping tasks they perform internally.
By comparison, SQL stored procedures are not precompiled. They are SQL scripts that are loaded and executed by Advantage in response to a client's invocation of the corresponding stored procedure object. SQL stored procedures were first introduced in Advantage 8.
The following sections provide you with a detailed description of the structural characteristics of both AEPs and SQL stored procedures.