RUN STORED-PROC statement with send-sql-statement option

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.