Stored Procedures and Open SQL
PostgreSQL user-defined functions written in PL/pgSQL or SQL languages can be invoked with
RWDBOSql using
SELECT syntax.
RWDBOSql myOpenSqlObject("SELECT * FROM myStoredFunc($1, $2);", RWDBOSql::Procedure);
In this example, myStoredFunc is the name of the stored function, and $1 and $2 are placeholders for the parameters to be passed to the function. Note the hint provided as RWDBOSql::Procedure. The return value, if any, is returned as a result set.
Please see
Open SQL Stored Procedure Examples for an example that uses
RWDBOSql with stored procedures.
