When you use database stored procedures in a PowerBuilder application, keep the following points in mind:
-
Manipulating stored procedures
To manipulate database stored procedures, PowerBuilder provides SQL statements that are similar to cursor statements.
-
Retrieval and update
PowerBuilder supports retrieval, update, or a combination of retrieval and update in database stored procedures, including procedures that do not return a result set and those that return a result set.
-
Transactions and procedures without result sets
When a procedure executes using a particular connection (transaction) and the procedure does not return a result set, the procedure is no longer active. No result set is pending and, therefore, you do not execute a CLOSE statement.
