TDBSP oracle with parameters Input

[Anonymous]

Dear All,

can you help me how to put parameters for the procedure DO_ETL:

this is my procudere DO_ETL with parameter In V_NUMDATE:

this is tDBSP oracle: i want input parameter get from server file or some table in the DB server.

regards,

Tr

[fdenis]

to add parameters click on the green "+" button on the bottom.

help is here: https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/L0CYRx_eeECbzhM8vJAMFg

[Anonymous]

thank Francois Denis,

i know that, but How can I get the parameter values ​​from the text file and put in the TBSP oracle component?

[fdenis]

read file first.

use tmap to extract your params

use column names to select Schema Colune name.