Skip to Content
Oct 15, 2013 at 06:41 AM

Program failing with SAPSQL_SQLS_INVALID_CURSOR in EHP7



We have a program that worked fine in all previous EHP releases, until the latest EHP7 ( Release 617 ).

The program gives a dump with the following runtime error: SAPSQL_SQLS_INVALID_CURSOR.

The dump accurs in a SELECT .... ENDSELECT statement, with a very large PACKAGE SIZE parameter ( that should run the select at once ) and inside the SELECT....ENDSELECT we perform CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD.

We understand that calling the CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD method performs a DB commit that closes the cursor opened by SELECT...ENDSELECT, but it seems that in previous versions, when the PACKAGE SIZE was large enough to make the select in one piece, it didn't bother to raise the exception.

Did anyone notices this change of behaiviour in the newest EHP7 release? Any idea how this can be solved?

Thanks in advance