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