How to send parameter to tOracleSP

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

Thanks!