@Dheeraj
I have a 10 rows in Database with field name ‘Product_ID’ so in pipeline after getting the field i have to take last number like in ‘P-00010’ i have to take ‘0’ and increment by 1 in pipeline and update back to the database like ‘P-00011’ .
Hope you got my point, Please give me solution
eval did not work for me
I solved it by adding a mapper in front of oracle-execute and mapped parameters to mapper output and used the mapper output in the sql and it worked
My new select statement is
“select * from obia1." + $tableName + " partition (” + $partName + “) where rownum < 11”
$tableName and $partName are outputs from mapper
