topic Re: Pass input parameters to oracle SP in Talend Studio

Pass input parameters to oracle SP

Anonymous — Thu, 02 Feb 2017 04:51:36 GMT

Hi,
As per my requirement,I am having a SP which creates a file in a described path.The input parameter for my SP is the filename which is VARCHAR.I tried to pass the input value through tFixedFlowInput but I am getting Java compilation errors
I have attached the screenshots for I have declared the values.

Kindly suggest how should the input variable be declared

Thanks

Re: Pass input parameters to oracle SP

Anonymous — Tue, 07 Feb 2017 09:25:51 GMT

Hi,
Have you already checked KB article about:TalendHelpCenter:Calling a stored procedure or function?
We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.

Best regards
Sabrina

Re: Pass input parameters to oracle SP

Anonymous — Thu, 16 Feb 2017 12:41:15 GMT

Hi

Now have passed the file name in custom name.The system doesn't throw any errors but I am not getting the required output in the specific path directory.
Please find the screenshot for the same.