Thank you, Shong. I tried tOracleRow and it works. Although I can execute whatever complex SQL statement with tOracleRow, but it lose the beauty to define data flow visually. Hope this bug can be fixed soon.
I have another question about tELTOracleMap in general. My goal is to join tables, filtering by some conditions, order by some fields, and then pipe the output to a CSV file. I discover that I cannot pipe tELTOracleMap to a tFileOutputDelimited directly. Instead, I need to feed output to an intermediate table first, and create another subjob to extract from intermediate table to a tFileOutputDelimited. Under normal JAVA JDBC environment, I would write code to iterate rows fetched and write them directly into a CSV file. I wonder how can this be accomplished by Talend without the need to create a intermediate table because that is a waste of disk space and perhaps runs slower?
I also tried a separate job to use tMap + tSortRow + tFileOutputDelimited to mimic the same functionality. It works, but is slower than the ELT SQL version.
Thank you for prompt response.
-Alice Chang-