topic insert data to oracle table in Application Development and Automation Discussions

insert data to oracle table

Former Member — Wed, 26 Jul 2006 06:53:15 GMT

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.

Re: insert data to oracle table

Former Member — Wed, 26 Jul 2006 07:48:07 GMT

is anyone know how can i resolve this problem?

thanks in advanced.

dana

Re: insert data to oracle table

Former Member — Wed, 26 Jul 2006 07:55:47 GMT

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

Re: insert data to oracle table

Former Member — Wed, 26 Jul 2006 07:59:41 GMT

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

Re: insert data to oracle table

ibrahim_u — Wed, 26 Jul 2006 08:03:07 GMT

what error you are having ?

Re: insert data to oracle table

Former Member — Wed, 26 Jul 2006 08:28:24 GMT

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.

Re: insert data to oracle table

Former Member — Sun, 30 Jul 2006 05:32:54 GMT

thank you all for your time,

it work fine now