โ11-27-2019 09:54 PM
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_lines partition (โ + _partName + โ) where rownum < 11โ
the value of parameter is not substituted in sql statement before it is executed
It fails with error =>
Failure: SQL operation failed, Reason: error occurred during batching: ORA-00972: identifier is too long , error code: 17081, Resolution: Please check for valid Snap properties and input data.
Solved! Go to Solution.
โ12-04-2019 06:28 AM
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
โ11-28-2019 12:51 AM
Hi, Try using eval function.
โ12-04-2019 06:28 AM
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