| |
- Causa
- THE CURSOR cursor-name IS NOT IN A PREPARED STATE.
The application program has tried to use a cursor, 'cursor-name,' that is not in a prepared state.
The cursor is associated with a statement that either (1) has never been prepared, or (2) has been invalidated by a commit or rollback operation.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- For case (1), ensure that you prepare the statement that is named in the DECLARE CURSOR statement for 'cursor-name' before you try to open the cursor.
For case (2), do one of the following:
- Use the WITH HOLD option of DECLARE CURSOR.
- Do not execute a commit or rollback operation until you are finished using the cursor.
- Prepare the statement again after the commit or rollback.
SQLSTATE: 26501
© Copyright IBM Corp.
|
| |
