I am trying to run a stored procedure using front end tools. The stored procedure is written in a cobol program. In the Cobol program a cursor is used to fetch data on a table. The cursor in the program is closed only for a particular condition. When I tried to execute my proc it is showing me the error that cursor is already opened. The cursor is not closed because the condition is not met . Can anybody tell me is there any method we can close the cursor. I don't which values I can provide to the proc to close the cursor.
I tried to stop the tablespace and start it but it didn't work.