sql - writing a EXECUTE statement in tOracleRow component using context variable -

sql - writing a EXECUTE statement in tOracleRow component using context variable -

i trying write execute statement in toraclerow.

at each iteration string prepared dynamically flow. here not discussing how have prepared string. 1 time prepared entire string stored in single context variable. illustration have next string stored in context variable @ given iteration number.

context.finalstring = "insert targettablename (columna, columnb) select col_a, col_b sourcetablename"

i trying execute string in toraclerow component using next statement:

"exec sql execute '"+context.finalstring+"'"

on running job getting next error.

ora-00900: invalid sql statement

kindly suggest solution. there way execute sql statement stored string in context variable?

try execute removing text exec sql execute ..just text should statement - insert table select col table... or update table set column=value ...

you dont need exec sql execute text here.

sql variables execute talend