Analytics Software

Dear Gurus,

         I have a File To RT interface. As a filter condition I have used the below(like) code:-

ARG.CENTRE_CODE_COLUMN = IN (select center_code from table_center_codes; )

but it is throwing ORA-00936: missing expression error.

What to do? Please advise.

At least please let me know how shall I implement my requirement? My requirement is:-

Suppose Src File needs to filtered based on its center code value  AA,BB,CC,DD,EE....etc.

i.e  ARG.CENTRE_CODE_COLUMN='AA'  OR ARG.CENTRE_CODE_COLUMN='BB'  OR ARG.CENTRE_CODE_COLUMN='CC'

Instead of using this long code I have stored these AA,BB...LookupValue (Filter Codes value)  in a separate table table_center_codes .

and use the code ARG.CENTRE_CODE_COLUMN = IN (select center_code from table_center_codes; ) I.E tried to get the Filter condition value

dynamically from the table_center_codes table.

But it fails.

Thanks

Papai

NB:- PLEASE LET ME KNOW YOU HAVE ANY CONFUSION ABOUT THE REQUIREMENT.