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.