topic Re: [resolved] Complex parameter in a stored procedure (tOracleSP) in Talend Studio

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

Anonymous — Fri, 02 Sep 2016 15:26:08 GMT

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

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

Anonymous — Mon, 05 Sep 2016 09:42:18 GMT

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

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

Anonymous — Fri, 16 Sep 2016 15:00:05 GMT

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.