Re: Cursor and Prepared statement

[Carol Nickel]

Unfortunately, it looks like prepare statements can't be used in cursors. From the manual: http://dev.mysql.com/doc/refman/6.0/en/sql-syntax-prepared-statements.html

"SQL syntax for prepared statements can be used within stored procedures, but not in stored functions or triggers. However, a cursor cannot be used for a dynamic statement that is prepared and executed with PREPARE and EXECUTE. The statement for a cursor is checked at cursor creation time, so the statement cannot be dynamic."

I would also be interested to know what the alternative is.