Dynamically Mapping columns to SELECT sql statement?
Summary
How to dynamically map DB table columns in SELECT sql in OIC?Content
Hi guys,
There is a requirement in my integration to decide at runtime which database table column needs to be queried using SELECT statement.
For example: If a database table has 50 columns i.e. Column1, Column2, Column3 …. Column50, and we are required to decide at runtime and fetch only one column (e.g. Column37 etc.) then how it can be achieved in OIC? I've identified the right column to be fetched, but couldn't find a way to incorporate it in SELECT statement dynamically in Oracle Integration Cloud (OIC).
0