Forum Discussion

GV2019's avatar
GV2019
New Contributor II
6 years ago
Solved

Oracle Table Partition Name as parameter

I have a child pipeline called from Pipeline Execute which is passing partition name as pipeline parameter to Oracle-Execute snap Oracle-Execute has a sql => “select * from obia1.sales_invoice_...
bmoturu's avatar
bmoturu
New Contributor
6 years ago

Hi, Try using eval function.

GV2019's avatar
GV2019
New Contributor II
6 years ago

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