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:
-
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)
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest