try to connect from sap to oracle

hello all,

i try to connect to oracle from sap

and for some reason when i do select from the outside table and want to move it to internal itab it move only the first row. (and i know that there is a lots of rows that it suppose to select).

my problem is that for some reason, in the loop, c always eq to 0.

my code is like this:

data c type cursor.

exec sql.

open c for

select a.part_id,a.plant,a.part_son,a.upd_date from ed700_sap_interface_bom a

endexec.

do

exec sql.

fetch next c into :itab_ed700-part_id

:itab_ed700-plant

:itab_ed700-part_son

:itab_ed700-upd_date

endexec.

if sy-subrc <> 0.

exit.

endif.

append itab_ed700.

enddo.

exec sql.

close c.

endexec.

any help will be appreciated.

dana.