[resolved] Complex parameter in a stored procedure (tOracleSP)

[Anonymous]

Hello everyone,
I want to use the tOracleSP which can perform functions / procedures with parameters. However I need to pass a parameter type (IN) as:
TYPE g_rec_param IS RECORD
(
l_param_name VARCHAR2(20),
l_param_type VARCHAR2(20),
l_param_value VARCHAR2(100)
);
I wanted to know if it was possible and if yes, how?
I looked on the internet without having an answer.

Thank you

[Anonymous]

Hi,
Could you please take a look at this section "Calling a stored procedure with parameters " in KB article: TalendHelpCenter:Calling a stored procedure or function?
Best regards
Sabrina

[Anonymous]

Hi,
I didn't find what i need in this KB Article. Also I decided to make a little trick in order to not pass complex paramater to a tOracleSP.
Thanks.