topic Re: [resolved] Multiple Insert when calling a stored procedure in Installing and Upgrading

[resolved] Multiple Insert when calling a stored procedure

Anonymous — Mon, 11 Jul 2016 20:45:41 GMT

Hi there,
I am new to Talend and creating my first talend job. I downloading a file and then calling a stored procedure to insert it into an oracle table. The issue I am running into is, when I run the job, it is inserting each record in the file multiple times. For instance there are seven records in the file and its inserting 7 iterations of that into the table.
I think I must be missing a component but not sure which one.
Any help would be much appreciated.
Thanks!
Giselle

Re: [resolved] Multiple Insert when calling a stored procedure

Anonymous — Wed, 13 Jul 2016 04:30:52 GMT

Hi,
Could you please indicate which component you are using in your job?
Have you already checked component TalendHelpCenter:tOracleSP which is used to call the database stored procedure.
Here is a KB article about:TalendHelpCenter:Calling a stored procedure or function
Best regards
Sabrina

Re: [resolved] Multiple Insert when calling a stored procedure

Anonymous — Tue, 19 Jul 2016 01:39:36 GMT

Hello there,
Yes I am using the tOracleSP. That is where I am having the issue. I am using the following components:
tfileInput>>tmap>>toracleoutput_1 (table used to load the file into)>>toraclesp (calling my stored procedure that inserts into table from the file data))>>toracle_oputput_2(oracle table my procedure inserts into)
I re-attached the screen shot within the job.
Thanks!
Giselle

Re: [resolved] Multiple Insert when calling a stored procedure

_AnonymousUser — Fri, 26 Aug 2016 07:25:59 GMT

Hello giselle,

I suspect you have given a main connection to the toraclesp component which is executed as many times as the number of rows you have in the input file. To fix this you should use on component OK or On Subjob ok link from the main job loading data from file to a table first.
tfileInput>>tmap>>toracleoutput_1 (table used to load the file into)>> (On component OK/On Subjob OK) toraclesp >>toracle_oputput_2
Regards,
Praveen K Bandi