SQL_PROCEDURE_EXECUTE¶
Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
This command is used to execute the SQL procedure created by the SQL_SET_PROCEDURE_NAME. If the results will be sent to the record buffer directly, then the file must be specified. An optional parameter can also be passed, indicating the maximum number of rows to be sent to the local cache. This is done by adding the constant ROWCOUNT followed by the maximun number.
Syntax
SQL_PROCEDURE_EXECUTE [of {file} ROWCOUNT {variable}]
Parameter |
Description |
|---|---|
file |
Name or number of the file (optional) |
variable |
Maximum number of rows to send to the local cache (optional) |
Usage
SQL_PROCEDURE_EXECUTE
SQL_PROCEDURE_EXECUTE of Customer
SQL_PROCEDURE_EXECUTE of Customer ROWCOUNT 10
Example
SQL_SET_PROCEDURE_NAME "sys.sp_addmessage" NUMPAR 3
SQL_SET_PROCEDURE_PARAMETER 1 to 500004 IN
SQL_SET_PROCEDURE_PARAMETER 2 to 15 IN
SQL_SET_PROCEDURE_PARAMETER 3 to "Please enter a valid Date" IN
SQL_PROCEDURE_EXECUTE