Stored Function Limitations

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}