This chapter describes the Stored Procedure Language (SPL). SPL is a highly productive, procedural programming language for writing custom procedures, functions, triggers, and packages of PolarDB.
SPL provides the following features for developing applications:
- Full procedural programming functionality to complement the SQL language.
- A single, common language to create stored procedures, functions, triggers, and packages of PolarDB.
- Integration with PgAdmin III, providing a seamless development and testing environment.
- The use of reusable code.
- Ease of use.
This chapter describes the basic elements of an SPL program, the organization of an SPL program, and how it is used to create a function or stored procedure.
In addition, this chapter delves into the details of the SPL language and provide examples of its application.