Stored Procedure¶
In GaussDB(DWS), business rules and logics are saved as stored procedures.
A stored procedure is a combination of SQL, PL/SQL, and Java statements, enabling business rule code to be moved from applications to databases and used by multiple programs at a time.
For details about how to create and invoke a stored procedure, see section "CREATE PROCEDURE" in SQL Syntax.
The functions and stored procedures created by using PL/pgSQL in PL/pgSQL Functions are applicable to all the following sections.