Support for Functions and Stored Procedures

Availability

This feature is available since openGauss 1.1.0.

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

Support for nested arrays in PL/SQL.

Support for using default argument values for cursors in PL/SQL.

Support for getting the type of a row of records in a table, view, or cursor by ROWTYPE in PL/SQL.

Constraints

Not supportted to call functions by a nested array's array-type element referred by suscripts.

Not supportted to assign a nested array's array-type element directly.

Can't get the type of a nested cursor by ROWTYPE.

Dependencies

None