Run a stored procedure

[sunbaj]

Hi,

I need to run a stored procedure in which I would pass a parameter and update a filed. This stored procedure would be executed after updating a table. I have not been able to set the parameters in Talend to pass it over to SP. How can I achieve this. This is fairly a simple task but unable to achieve it.

This is the simple SP which I need to run

create or replace PROCEDURE UPDATE_PROCESSED_FILE_LIST
(
FILE_NAME IN VARCHAR2
) AS
BEGIN
update file_list set FILE_PROCESSED = 'Yes' where file_name = FILE_NAME;
END UPDATE_PROCESSED_FILE_LIST;

[manodwhb · Accepted solution]

@sunbaj , your job design should be as below. please check.

[sunbaj]

Hi Manihar,

I basically am running a process where in I read file names from a database and then process the files one by one in an iterative manner. So when the first file is loaded I would like to run the SP which would take that file which has just been processed and update a column named File_Processed to "Yes". So that is why I would like to run this at the end. So what I see is the only way to execute this stored proc is to have a file which passes that file name to the stored proc as per the solution that you have given ?

[manodwhb]

@sunbaj , once you process the file successfully the take on component ok from the tDBoutput and design the next job the way I thave give and in the filename column pass the global variable of the filename which you were iterating.