What
you can do with Oracle stored procedures
Ways to use Oracle stored
procedures
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
procedureFor 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
DataWindow objects 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.