topic Re: Problem in insert command in Native SQL in Application Development and Automation Discussions

Problem in insert command in Native SQL

I066686 — Tue, 22 Sep 2009 11:57:07 GMT

Hi Experts,

I have to update one external oracle table by dbcon connection using function module.

I have made the connection but there is some problem in insert command while using variables instead of values

 
  EXEC SQL.
   insert into wfh_ood VALUES (1234567, '20-sep-2009', '21-sep-2009' , 05)
  ENDEXEC.

When i execute this query it is updating the table. If i use the variables instead of values 
It is showing dump


EXEC SQL.
insert into wfh_ood VALUES (emp_no, start_date1, end_date1, status)
ENDEXEC.

in oracle table i have given all as Char except Emp_no as integer.

Experts help me in this issue.

with thanks and regards,

Kiruba.

Former Member — Tue, 22 Sep 2009 12:26:44 GMT

Hi Kiruba,

In order to communicate with the rest of your program, you have to add ":" behind your variables like this :

EXEC SQL.
INSERT INTO wfh_ood VALUES (:emp_no, :start_date1, :end_date1, :status)
ENDEXEC.

(SQL code is not ABAP code...)

Best regards,

Samuel

I066686 — Wed, 23 Sep 2009 05:33:29 GMT

Thanks a lot.I could able to solve the problem.