Pass Oracle connection to Routine

[Anonymous]

Hi Team,

Is there any sample code for passing oracle tDbConnection to rountine and prcoess db records (Do some select * from table query) in routine.

[Anonymous]

Hi,

    Why are you running the Oracle connection inside a routine? You can always extract the data set using Oracle native components like tOracleInput or tOracleRow and then you can use this result set for further processing.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Anonymous · Accepted solution]

Hi,

   Though, We can extract data using Oracle components, But if required we can pass the connection to Talend Routines as well. Create a Db connection using tOracleConnection component. Then go to the code section of the job where you can get the object name which you can pass to your Talend routine.