How to Pass Parameters to Store Procedure in tOracleSP in Talend.

Five Stars

How to Pass Parameters to Store Procedure in tOracleSP in Talend.

How to Pass Parameters to Store Procedure in tOracleSP. Please explain in detail.

 

Thanks,

Jagadesh


Accepted Solutions
Moderator

Re: How to Pass Parameters to Store Procedure in tOracleSP in Talend.

Hello,

For your job requirement, you can use a tFixedFlowInput component to generate a fixed data flow and then pass the values of input parameters to the stored procedure.

The work flow should be: tfixedflow-->tOracleSp-->output.

Please take a look at this online document about:TalendHelpCenter:Calling a stored procedure or function.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: How to Pass Parameters to Store Procedure in tOracleSP in Talend.

Hello,

For your job requirement, you can use a tFixedFlowInput component to generate a fixed data flow and then pass the values of input parameters to the stored procedure.

The work flow should be: tfixedflow-->tOracleSp-->output.

Please take a look at this online document about:TalendHelpCenter:Calling a stored procedure or function.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download