[resolved] Parameters for a function in tMysqlSP

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

Best regards
Sabrina

[Anonymous]

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.

[Anonymous]

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

[Anonymous · Accepted solution]

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

Best regards
Sabrina

[Anonymous]

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!

[Anonymous]

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