Stored Procedure

In GaussDB, business rules and logics are saved as stored procedures.

A stored procedure is a combination of SQL and PL/SQL. Stored procedures can move the code that executes business rules from applications to databases. Therefore, the code storage can be used by multiple programs at a time.

For details about how to create and call a stored procedure, see CREATE PROCEDURE.

The application methods for PL/SQL functions mentioned in PL/SQL Functions are similar to those for stored procedures. Unless otherwise specified, the following sections apply to stored procedures and PL/SQL functions.