topic Something about open cursor . in Application Development and Automation Discussions

Something about open cursor .

Former Member — Wed, 09 Apr 2008 14:40:29 GMT

Guys , I need an advice, I'm doing the following code, but I´n not sure if it can work or could be very slow , the thing is that que ti_referenc could have more than 1 million entries , what else is possible to do ?

LOOP AT ti_referenc.

OPEN CURSOR WITH HOLD cursor1 FOR

SELECT * FROM zpf_cob_doc_ext

WHERE referencia = ti_referenc-ref.

FETCH next cursor cursor1

APPENDING CORRESPONDING FIELDS OF TABLE it_zpf_cob_doc_ext

PACKAGE SIZE p_commit.

CLOSE CURSOR cursor1.

ENDLOOP.

thank you a lot.

Re: Something about open cursor .

Former Member — Wed, 09 Apr 2008 14:44:23 GMT

hi,

You can even add additional code as below ..

OPEN CURSOR WITH HOLD cursor1 FOR

SELECT * FROM zpf_cob_doc_ext

WHERE referencia = ti_referenc-ref.

DO.

FETCH next cursor cursor1

APPENDING CORRESPONDING FIELDS OF TABLE it_zpf_cob_doc_ext

PACKAGE SIZE p_commit.

IF sy-subrc <> 0.

CLOSE CURSOR cursor1.

EXIT.

ENDIF.

ENDDO.