insert data to oracle table

[Former Member]

hello all,

i have to insert data to oracle, and my code look ok but there is a dump.

i did the following things:

begin of it_report occurs 0,

aufnr(8) type c,

objkey1(12) type c,

endof it_report.

loop at it_report.

exec sql.

insert into oracle_table

wo,

pck_change

values (

:it_report-aufnr,

:it_report-objkey1 ).

commit work.

endexec.

endloop.

is anyone know what is the problem?

thanks in advanced'

dana.

[Former Member]

is anyone know how can i resolve this problem?

thanks in advanced.

dana

[ibrahim_u]

what error you are having ?

[Former Member]

The error i got:

"the error occured in the database connection "DEFAULT".

database error text: missing values keyword#"

Triggering SQL statement:"insert into oracle_table,cancelled values( ?,? ) commit work.

thanks in advanced.

dana.

[Former Member]

thank you all for your time,

it work fine now

[Former Member]

Hi ,

The problem may be because of "END OF" statement in it-report structure declaration. You have written it as endof. Can you just try it once.

Give some more information on type of error by checking the dump.

Regards,

Amit.

Message was edited by: amit bhadauria

Message was edited by: amit bhadauria

Message was edited by: amit bhadauria

[Former Member]

Hi Dana,

Could you explain what the Runtime Error Explains( Error Analysis in Dump). This would help to figure out the Problem.

Thanks and Regards,

Prashanth