This topic describes the Stored Procedure Language (SPL). SPL is a highly productive, procedural programming language for writing custom procedures, functions, triggers, and packages for PolarDB for PostgreSQL(Compatible with Oracle). SPL provides:

  • Full procedural programming functionality to complement the SQL language
  • A common language to create stored procedures, functions, triggers, and packages for PolarDB for PostgreSQL(Compatible with Oracle)
  • A seamless development and testing environment
  • The use of reusable code
  • Ease of use

This chapter describes the basic elements of an SPL program, and then provides an overview of the organization of an SPL program and how it is used to create a procedure or a function.