I have similar issue, I searched everywhere but don't know how to get the output into context variable using tOracleRow.
( Have done this with tOracleinput many times (tOracleinput -- tLogRow -- ... --) )
I have created a pl sql block in which I get some data .
--"+ context.REASON +" :=REASON;
-- dbms_output.put_line( DIRECTORY_NUMBER1 );
-- dbms_output.put_line( STATUS_CODE1 );
-- dbms_output.put_line( REASON1 );
dbms_output.put_line ('var_main_1 ' || var_main_1 );
from there I want to get the data in the context variable. I tried many many things but I can't get this done .
My talend flow will be like (tFileInputExecel -- tJavaRow -- tOracleRow)
This is just a POC , We will get number output from this query and I will use bulk collect in my original query if this POC is successful.
Any advice will be appriciated.