Runtime Error DBSQL_INVALID_CURSOR (Cursor already closed or not open yet)

former_member651247 — Sat, 05 Feb 2022 15:42:11 GMT

Hello Friends,

I am receiving runtime error as " Cursor already closed or not open yet." for the below piece of code.

So, can anyone please help me how to solve it?

I have tried DB_COMMIT FM for commit work and also without it, still the same dump occurs.

data: gv_cursor TYPE cursor.

OPEN CURSOR WITH HOLD gv_cursor

FOR SELECT
erdk~opbel
fkkvkp~ktokl
FROM erdk AS erdk
INNER JOIN fkkvkp AS fkkvkp
ON fkkvkp~vkont = erdk~vkont
WHERE erdk~opbel IN s_prtdoc.

DO.

FETCH NEXT CURSOR gv_cursor
INTO TABLE gt_input
PACKAGE SIZE 1000.
IF sy-subrc IS INITIAL.
SORT gt_input BY opbel.
ELSE.
CLOSE CURSOR gv_cursor.
EXIT.
ENDIF.

****Some other logics is implemented below.

ENDDO.

Re: Runtime Error DBSQL_INVALID_CURSOR (Cursor already closed or not open yet)

Sandra_Rossi — Sat, 05 Feb 2022 16:19:47 GMT

Does it work without code from "other logics"?

topic Runtime Error DBSQL_INVALID_CURSOR (Cursor already closed or not open yet) in Application Development and Automation Discussions

Runtime Error DBSQL_INVALID_CURSOR (Cursor already closed or not open yet)

Re: Runtime Error DBSQL_INVALID_CURSOR (Cursor already closed or not open yet)