topic [resolved] Parameters for a function in tMysqlSP in Talend Studio

[resolved] Parameters for a function in tMysqlSP

Anonymous — Tue, 08 Dec 2015 02:03:00 GMT

Hi all,

I tried to call a function with parameters inside a tMysqlSP component.
I don't even know if it's possible actually.
I didn't get the answer in the documentation of Talend.

Please see the screenshots below to help me find out my mistake.

Thank you for your advice.

Re: [resolved] Parameters for a function in tMysqlSP

Anonymous — Fri, 11 Dec 2015 07:11:28 GMT

Hi,
Did you input the exact name of the Stored Procedure into "SP name"? Don't forget to add the double quote around your SP name.
Have you already checked the scenario in the component reference:TalendHelpCenter:tMysqlInput?

Best regards
Sabrina

Re: [resolved] Parameters for a function in tMysqlSP

Anonymous — Tue, 15 Dec 2015 02:03:26 GMT

Hi xdshi,
I did put the exact same name with the double quote and if so I get a different error (see screenshot below)
Thx for helping.

Re: [resolved] Parameters for a function in tMysqlSP

Anonymous — Wed, 16 Dec 2015 08:13:06 GMT

Hi,
Does this issue repro on your other Stored Procedures? What's the build version you are using?

Best regards
Sabrina

Re: [resolved] Parameters for a function in tMysqlSP

Anonymous — Wed, 16 Dec 2015 09:01:13 GMT

Hi,

I use TOS 6.1.0.20151029_1337.

It works if I use the same stored procedure without parameters.
I mean if I add the parameters inside variables inside the stored procedure and I call the procedure in TOS like this "MyProcedure" it works fine.

But it doesn't solve my problem because I really need to call this procedure WITH parameters.

Thx.

Re: [resolved] Parameters for a function in tMysqlSP

Anonymous — Mon, 21 Dec 2015 09:21:29 GMT

Hi xdshi,
Any update about my issue?
Thx.
Johan.

Re: [resolved] Parameters for a function in tMysqlSP

Anonymous — Mon, 21 Dec 2015 09:54:32 GMT

Hi,
Could you please take a look at this KB article about: TalendHelpCenter:Calling a stored procedure or function?

Best regards
Sabrina

Re: [resolved] Parameters for a function in tMysqlSP

Anonymous — Mon, 21 Dec 2015 12:09:44 GMT

Thank you very much.

I finally understand that a second component is needed: tFixedFlowInput
So I can create 2 variables with fixed values that I can set up manually.
Then I can use these 2 variables as 2 IN parameters inside the tMysqlSP.

Thx again xdshi!

Re: [resolved] Parameters for a function in tMysqlSP

Anonymous — Tue, 22 Dec 2015 03:15:31 GMT

Hi,
Great you got it. Thanks for marking this topic as resolved.
Best regards
Sabrina