RUN STORED-PROC statement with send-sql-statement option
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
ABL also allows you to use stored-procedure
syntax to send SQL statements and their native language extensions
directly to a data source. The DataServer uses the RUN STORED-PROCEDURE statement
with the send-sql-statement option to pass SQL
statements to the data source. However, the Oracle DataServer only
supports one SQL statement or PL/SQL block with the send-sql-statement
option.
Like the option to define a RUN STORED-PROC statement
either with or without the LOAD-RESULT-INTO options,
you can define a send-sql-statement option with or without the LOAD-RESULT-INTO option.
The following section presents and briefly describes an example
use of each technique.