I also had a similar issue and after trying many possibilities may have found the solution. When you create the 2nd parameter try this...
" where branch_cd = '$P!{b_cd}' "
Also, remember to put this syntax in the where clause of the SQL statement: P$!{<Parameter_name>}, where P${<Parameter_name>} is the 2nd parameter and equals " where branch_cd = '$P!{b_cd}' ".
Nested Parameters Give Error
in Products
Posted
I also had a similar issue and after trying many possibilities may have found the solution. When you create the 2nd parameter try this...
" where branch_cd = '$P!{b_cd}' "
Also, remember to put this syntax in the where clause of the SQL statement: P$!{<Parameter_name>}, where P${<Parameter_name>} is the 2nd parameter and equals " where branch_cd = '$P!{b_cd}' ".
Hope this helps someone.