PowerBuilder provides SQL statements that are very similar to cursor operations to support retrieval using database stored procedures. In PowerBuilder embedded SQL, there are four commands that involve database stored procedures:
-
DECLARE procedure_name PROCEDURE FOR ... (Oracle DECLARE and EXECUTE)
-
EXECUTE procedure_name (Oracle DECLARE and EXECUTE)
-
FETCH procedure_name INTO ... (Oracle FETCH)
-
CLOSE procedure_name (Oracle CLOSE)
