You can use an Oracle stored procedure in the following ways in your PowerBuilder application:
As a data source for DataWindow objects
Called by an embedded SQL DECLARE PROCEDURE statement in a PowerBuilder application (includes support for fetching against stored procedures with result sets)
Called as an external function or subroutine in a PowerBuilder application by using the RPCFUNC keyword when you declare the procedure
For information about the syntax for using the DECLARE PROCEDURE statement with the RPCFUNC keyword, see the PowerScript Reference.
Procedures with a single result set You can use stored procedures that return a single result set in reports and embedded SQL, but not when using the RPCFUNC keyword to declare the stored procedure as an external function or subroutine.
Procedures with multiple result sets You can use procedures that return multiple result sets only in embedded SQL. Multiple result sets are not supported in DataWindows, reports, or with the RPCFUNC keyword.
