Stored Function Limitations

This page details the restrictions on stored functions, such as the inability to return result sets or use transaction control statements.

The following restrictions apply to stored functions.

• All of the restrictions listed in Stored Routine Limitations.

• Any statements that return a result set are not permitted. For example, a regular SELECTs is not permitted, but a SELECT INTO is. A cursor and FETCH statement is permitted.

• FLUSH statements are not permitted.

• Statements that perform explicit or implicit commits or rollbacks are not permitted.

• Cannot be used recursively.

• Cannot make changes to a table that is already in use (reading or writing) by the statement invoking the stored function.

• Cannot refer to a temporary table multiple times under different aliases, even in different statements.

• ROLLBACK TO SAVEPOINT and RELEASE SAVEPOINT statement which are in a stored function cannot refer to a savepoint which has been defined out of the current function.

• Prepared statements (PREPARE, EXECUTE, DEALLOCATE PREPARE) cannot be used, and therefore nor can statements be constructed as strings and then executed.

_{This page is licensed: CC BY-SA / Gnu FDL}