Five Stars

designing a talend job for store procedure

hi floks,

I have created a store procedure in oracle,

the function of store procedure is to implement upsert operation on a table.
so i want to implement that store procedure in talend.
As i am new to the tool can you please help me out with steps

2 REPLIES
Seven Stars

Re: designing a talend job for store procedure

@mouryas20 - how about

tOracleInput -> tOracleOutput and selecting 'Action on data' as 'Insert or Update' in 'tOracleOutput' component.

 

 

Ten Stars

Re: designing a talend job for store procedure

hi,
You ca call sored procedure using tOracleSP
https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/nZLZAcmLjEt8X8yaaf3lfQ
regards,

Francois Denis

Don't forget to tag when it's "solved"!