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

1 ACCEPTED SOLUTION

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.
1 REPLY
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.