tELTOracleMap - "CONTEXT"."PROCESS_NUM": invalid identifier

[Anonymous]

Hi,

I have 2 tELTmaps for inner query and outer query concept. 

Inner query: order the data by primary key

Outer query: retrieves n rows

Complete query:

"select * from (

select * from table t1, table t2 where t1.id = t2.id and mod(t1.id, 2) = " + CONTEXT.PROCESS_NUM + " order by t1.id

)

where rownum <= "+  CONTEXT.ROW_NUM

Both PROCESS_NUM and ROW_NUM are defined in context but the query recognizes the outer context variable but not the inner context .variable.

Tried placing inside single quote ', but still errors. Any support please.

Thanks