View previous topic :: View next topic
|
Author |
Message |
nagesh54
New User
Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad
|
|
|
|
Hi,
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. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
stored procedure is written in a cobol program |
either the SP is a COBOL Program or it was CALLed from a COBOL Program.
Quote: |
The cursor in the program is closed only for a particular condition |
sounds as if you (or someone) has to revisit the SP and determine the condition.
I would think that stoping the SP TASK would close the cursor. |
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi Nagesh
Are you using result set concept?
Regards
Raghu |
|
Back to top |
|
|
|