Native SQl

[Former Member]

Hi All,

I have one internal table with 4 fields and i have to update into oracle database table using native SQl.

if i update the table with values it's working fine and how to pass the values to tables from my internaltable variable with in the loop.

Any having idea how to make it.

[former_member206377]

Hi Ramesh,

check the following link

http://help.sap.com/saphelp_nw04/helpdata/EN/a3/74caa1d9c411d1950e0000e8353423/content.htm

http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

Hope it helps.

Edited by: Vasuki S Patki on Nov 19, 2009 2:55 PM

[Former Member]

Hi Vasuki,

Thanks for the response. do u have any idea for the INSERT Statement to store the values fom the internal table to dB table using native SQL.

[former_member206377]

Hi Ramesh,

Do you mean the syntax?

EXEC SQL.
INSERT INTO table_name VALUES (:value1, :value2) " any number of values
ENDEXEC.

[former_member206377]

Hi Ramesh,

Is your issue resolved?