SQL_SET_PROCEDURE_NAME¶
Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
This command is used to set the procedure to be executed. This is used when the procedure is being split up into multiple lines as shown below. When using this command, SQL_PROCEDURE_EXECUTE must be called after all parameters have been set to successfully execute the procedure. The constant “NUMPAR” is used to indicate how many parameters will be passed.
Syntax
SQL_SET_PROCEDURE_NAME {procedure} NUMPAR {variable}
Parameter |
Description |
|---|---|
procedure |
Full name of the procedure |
variable |
Number of parameters to be passed |
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