Using DECLARE, EXECUTE, FETCH, and CLOSE with Oracle stored procedures

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: