Solution : https://service.sap.com/sap/support/notes/675 (SAP Service marketplace login required)
Summary :
SAP Note addresses a runtime SQL error encapsulated as "DBIF_RSQL_INVALID_CURSOR" occurring post-commit in a SELECT loop. The error arises due to the database cursor being lost following a COMMIT or ROLLBACK operation within the loop. The cursor's loss interrupts the SELECT loop's continuity since the system cannot automatically resume the loop. This error is generally triggered by any transaction that necessitates a screen change, debug breakpoints, or WAIT conditions that inherently perform COMMIT operations. Avoiding COMMIT-inducing statements within SELECT loops is recommended to prevent cursor loss and ensure seamless runtime operation.
Key words :
commit work/rollback work solution, sql abendat run-time, run-time error dbif_rsql_invalid_cursor, sql error occurs, symptom key word, additional key words, break-point / debugging, release generation lock, debug process free, work process
Related Notes :
| 331662 | DBIF_RSQL_INVALID_CURSOR when executing RM06ENP1 |
| 2104 | Error messages DBIF_...._INVALID_CURSOR |