Support for Functions and Stored Procedures

Availability

This feature is available since V300R002C00.

Introduction

Functions and stored procedures are important database objects. They encapsulate SQL statement sets used for certain functions so that the statements can be easily invoked.

Benefits

1. Allows customers to modularize program design and encapsulate SQL statement sets, easy to invoke.
2. Caches the compilation results of stored procedures to accelerate SQL statement set execution.
3. Allows system administrators to restrict the permission for executing a specific stored procedure and controls access to the corresponding type of data. This prevents access from unauthorized users and ensures data security.

Description

openGauss supports functions and stored procedures compliant with the SQL standard. The stored procedures are compatible with certain mainstream stored procedure syntax, improving their usability.

Enhancements

None

Constraints

None

Dependencies

None