Error in select query with package size

[Former Member]

Hi Experts,

I have an issue.

SELECT * FROM (w_tab-tablename) I

NTO CORRESPONDING FIELDS OF TABLE <lt_data> PACKAGE SIZE 10000.

Am splitting the table for every 10000 records,for first time the select query is successful.

But when it comes for the second 10000 records,its throwing the following dump.

"DBIF_RSQL_INVALID_CURSOR"

Help Appreciated

[Former Member]

Hi Experts,

I have an issue.

SELECT * FROM (w_tab-tablename) I

NTO CORRESPONDING FIELDS OF TABLE <lt_data> PACKAGE SIZE 10000.

Am splitting the table for every 10000 records,for first time the select query is successful.

But when it comes for the second 10000 records,its throwing the following dump.

"DBIF_RSQL_INVALID_CURSOR"

Help Appreciated

[Former Member]

Hi,

I am suggesting you that please omit corresponding fields and

and one thing you need to remember.

selecting fields using select * statement .. data values internally will be in sequential order.

for example .

field 1, field 2,, ... fn like that.

so the table which you are using to store values should have same sequence of fields.

otherwise it may be goes to dump which out showing any error messages.

Regards,

Prasad

[Former Member]

Hi vadnalav,

I understand this error is coming while you are debugging.

This error will not come if you do not debug. While debugging, it will come in the 2nd loop error.

This is by design. Debugging causes a commit work, and hence closes the current cursor. So just put your break-point after the full loop, if u want to debug. Do not debug in between the loop.

For reference, see this

[|]

regards,

amit m.

[Former Member]

Hi,

There are a few instances where you get this error.

1) If you are debugging inside select ... endselect.

2) You have written any of the below statements inside select ... endselect.

Please look at the dump .. you'll find the below ..

MESSAGE (apart from MESSAGE S...)

COMMIT WORK

ROLLBACK WORK

BREAK-POINT

WAIT

CALL FUNCTION ... DESTINATION (synchronous RFC)

CALL FUNCTION ... STARTING NEW TASK

RECEIVE RESULTS

CALL DIALOG

CALL SELECTION-SCREEN

CALL TRANSACTION

CALL SCREEN, or any other statement that results in the display of a

new screen

Regards,

Srini.