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 compatible with Oracle.

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 clusters compatible with Oracle.
  • 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.