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!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’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

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now