How to send parameter to tOracleSP

Highlighted
One Star

How to send parameter to tOracleSP

I need to execute a stored procedure, but I need to pass a variable in. In the parameter list it only shows the fields from the schema. I need to pass in a process name to retrieve the last run date, but I don't need this data in the schema, how can I accomplish this?

Thanks,
Marcie


Accepted Solutions
Community Manager

Re:How to send parameter to tOracleSP

Hi
Using a tFixedFlowInput to generate one data flow and pass the parameter to tOracleSP component. For exmaple:
...other processing of the job..
|
onsubjobok
|
tFixedFlowInput--main--tOracleSP
Let's say that you want to pass an ID to your procedure as in paramter, define one column called 'id' on the schema of tFixedFlowInput
column:value
id:1

----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re:How to send parameter to tOracleSP

Hi
Using a tFixedFlowInput to generate one data flow and pass the parameter to tOracleSP component. For exmaple:
...other processing of the job..
|
onsubjobok
|
tFixedFlowInput--main--tOracleSP
Let's say that you want to pass an ID to your procedure as in paramter, define one column called 'id' on the schema of tFixedFlowInput
column:value
id:1

----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] How to send parameter to tOracleSP

Thanks!

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download