END_CALL_PROCEDURE¶
Applies to: SQLFlex
This command is used to close any open cursors created by the respective stored procedure. Cursors are used in MSSQL to make the results from one procedure temporarily available to other procedures or triggers. To avoid causing unwanted results, it is good practice to use this command once a procedure call is completed.
Syntax
END_CALL_PROCEDURE
Example
CALL_STORED_PROCEDURE "sys.sp_spaceused" Passing "Customer"
GET_PROCEDURE_RETURN to sValue
END_CALL_PROCEDURE
Showln sValue