Skip to Content
0
Nov 08, 2012 at 02:25 PM

Time Out error for select statement

181 Views

Hi Folks,

OPEN CURSOR WITH HOLD c1 FOR SELECT ordid ordno FROM /1OM/ORDR7MP3100
FOR ALL ENTRIES IN gt_po_details
where ordid = gt_po_details-ordid AND prtid = gt_po_details-prtidto.
DO.


>>>>>>>>>> FETCH NEXT CURSOR c1 INTO TABLE gt_po4 PACKAGE SIZE 10000.

IF SY-SUBRC EQ 0.
APPEND LINES OF gt_po4 TO gt_po_numbers.
ELSE.
EXIT.
ENDIF.
ENDDO.
CLOSE CURSOR c1.
ENDIF.

ordid is primary key.i written select statement sequence is same as DB table field sequence.

This select statement is trying to get 200000 records from DB level.

AT fetch statement line its giving time out error.

Please help me to avoid timeout error.

Thanks in advance