Requirements and Constraints (EXECUTE STATEMENT)

Go Up to EXECUTE STATEMENT

There are constrains and peculiarities with using EXECUTE STATEMENT:

• Starting with InterBase XE7 Update 1, there is a new requirement on FOR EXECUTE STATEMENT to match every item in the SELECT list with a corresponding item in the INTO list.
• The Statement is "prepared" every time it is executed, which affects the performance of the Stored Procedure.
• No checks are done on the statement when the procedure is created; dependency checks are not done when the procedure is created, also the checks for existence of tables or column names referred in the execute statement are not performed. All these checks are done at execute time and results in errors if an error condition occurs.
• The feature can be used to perform DDL operations.
• All statements are executed based on the privileges of the user executing the Stored Procedure.
• SQL statements, "COMMIT:”, "COMMIT RETAIN", "ROLLBACK", "ROLLBACK RETAIN", and “CREATE DATABASE” are not supported with “EXECUTE STATEMENT”. These statements return the code isc_exec_stmt_disallow error.