topic Re: DBIF_RSQL_INVALID_CURSOR , CX_SY_OPEN_SQL_DB in Application Development and Automation Discussions

DBIF_RSQL_INVALID_CURSOR , CX_SY_OPEN_SQL_DB

Former Member — Fri, 17 Aug 2007 18:28:01 GMT

this above error is coming while processing select - endselect statement in ECC 6.0

former_member194669 — Fri, 17 Aug 2007 18:30:48 GMT

Hi,

Check whether you have commit in between a SELECT and ENDSELECT loop.

That is why you are getting this error.

a®

former_member194669 — Fri, 17 Aug 2007 18:32:50 GMT

Hi,

if you are doing a debugging the program in between SELECT - ENDSELECT, thenyou have to use F6 (and not F5) for step-by-step debugging.

aRs

Former Member — Fri, 17 Aug 2007 18:34:07 GMT

there is no commit

former_member194669 — Fri, 17 Aug 2007 18:36:31 GMT

Hi,

If you are debugging then

select

endselect

if sy-subrc eq 0. " <<< put the break-point here. if not

please paste the code in between select and endselect

a®

Former Member — Fri, 17 Aug 2007 18:41:17 GMT

hi,

if you are in the select loop and try to debug you will get this error.

are you selecting only few fields from the table... try with select * and see.

Thanks

Mahesh