topic Re: Native SQl in Application Development and Automation Discussions

Native SQl

Former Member — Thu, 19 Nov 2009 09:16:20 GMT

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 — Thu, 19 Nov 2009 09:23:57 GMT

Hi Ramesh,

check the following link

Hope it helps.

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

Former Member — Thu, 19 Nov 2009 09:32:07 GMT

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 — Thu, 19 Nov 2009 11:03:13 GMT

Hi Ramesh,

Do you mean the syntax?


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

former_member206377 — Thu, 19 Nov 2009 11:27:55 GMT

Hi Ramesh,

Is your issue resolved?