Stored Procedures

Stored procedures are encapsulated by the class RWDBStoredProc. The implementation of stored procedures in the DB Access Module for PostgreSQL provides full support for PostgreSQL user-defined functions written in PL/pgSQL or SQL languages. This includes support for creating and dropping functions, retrieving function text and parameters, executing functions, and processing result sets.

Refcursors in PL/pgSQL language functions are supported.

Composite return types in SQL language functions are not supported.

In this section: