cancel
Showing results for 
Search instead for 
Did you mean: 

Add 2 parameters in WHERE CLAUSE in Oracle Select

yes1819
New Contributor III

Hi,
I’m trying to put 2 parameters in Where Clause in Oracle Select with “and”
Below is my pipeline parameters. I put some values between ’ ’ (I don’t have to put it)

image

Below is my pipeline and Mapper settings
image

Below is my Oracle Select settings
image

I created trigger task, but when I put BEC_NAME and Prodcut_segment with Bearer_token, I don’t see data

I think this is caused by my where clause in the Oracle Select. Can you please help me?
FYI, I was successful to pull only 1 parameter (BEC_NAME)
Thank you

5 REPLIES 5

Supratim
Contributor III

@yes1819 Yes , your has syntax issue it took $product_segment as value.It will be something like - “BEC_NAME='” + $BEC_NAME + " and PRODUCT_SEGMENT=‘" + $PRODUCT_SEGMENT+ "’"

yes1819
New Contributor III

Thank you Supratim,
I tried, but got below error message

image

igormicev
Contributor

Hi @yes1819

Put this in your Where clause and try:

"BEC_NAME = '"+$BEC_NAME+"' AND PRODUCT_SEGMENT = '"+$PRODUCT_SEGMENT+"'"

/Igor

yes1819
New Contributor III

Thank you Igor.
Now, I got this error

image