topic Closing a cursor. in Application Development and Automation Discussions

Closing a cursor.

Former Member — Thu, 26 Aug 2004 14:39:01 GMT

Hi Friends,

In the execution of a standard SAP Function Module one of my programs is generating a dump stating the reason of

SAPSQL_CURSOR_ALREADY_OPEN.

How can I close this cursor and again run the program. Or can the Basis guys delete them.

Thanks and Regards,

Arunava

Re: Closing a cursor.

nablan_umar — Thu, 26 Aug 2004 15:42:46 GMT

Have you tried CLOSE CURSOR statment in your program?

Re: Closing a cursor.

ulrich_koch — Tue, 31 Aug 2004 08:21:19 GMT

Hello Arunava,

an open cursor is nothing that is persistent on the database. The short dump just means that an OPEN CURSOR statement is executed twice in a program. This is a programming error.

Best regards

Ulrich

Re: Closing a cursor.

Former Member — Tue, 31 Aug 2004 09:16:20 GMT

Hi,

This is cause of you are trying to open a cursor that is already open. Check the code that is giving the problem. Put the logic as Open cursor then close it before opening it again.

Or work with the original one do not open it again.

Regards,

amit