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.