Closing a cursor.

[Former Member]

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

[nablan_umar]

Have you tried CLOSE CURSOR statment in your program?

[ulrich_koch]

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

[Former Member]

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