This content has been marked as final. Show 4 replies
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.
NB:- PLEASE LET ME KNOW YOU HAVE ANY CONFUSION ABOUT THE REQUIREMENT.