Hi
The job looks like:
Father:
tOracleConnection_1 
   |
onsubjobok
    |
tFileInputExcel ---tFlowToIterated---iterate--> tRunJob
    |
onsubjobok
    |
tOracleCommit(finally, close the connection)

on tOracleConnection_1, check the box 'use or register a shared DB connection and type in a connection name.
on tRunJob, uncheck the box 'die on child job error', pass each row to child job via context variable(see [Forum, topic 1654] Passing context parameters in a tRunJob)

Child:
tOracleConnection_1
    |
onsubjobok
    |
tFixedFlowInput ---> tMap ---> tOracleOutput
                                       ---> tOracleOutput
    |
onsubjobok-->tOracleCommit(don't close the connection)
onsubjoberror-->tOracleRollback

on tOracleConnection_1, check the box 'use or register a shared DB connection and type in the connection name defined in the father job.

on tFixedFlowInput, generate each row passed from father job.

Best regards
Shong