In this blog post, let’s learn about the error message “260 Cannot execute a SELECT statement that is PREPAREd – must use cursor.” in Hydra and the description of the error.
Error Message
260 Cannot execute a SELECT statement that is PREPAREd – must use cursor.
Error Details
The current statement (EXECUTE or OPEN) refers to a prepared SQL statement or a cursor that does not exist. Possibly the statement id is invalid, or possibly the statement was prepared and then released with the FREE statement. Review the program logic to make sure that the statement or cursor that is named in this statement is valid, has been properly prepared or declared, and has not been freed prior to this point.
If the program executes a prepared DATABASE statement successfully, the database server automatically frees the prepared statement. As a result, if you free a prepared DATABASE statement, you will receive this error on the FREE statement. You can ignore it in this case.