09-22-2009 12:57 PM
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.
09-22-2009 1:26 PM
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
09-23-2009 6:33 AM