tOracleRow and variable context

Anonymous — Sat, 16 Nov 2024 14:15:29 GMT

Hi,
I call an Oracle procedure in my tOracleRow. When my procedure returns nothing it works perfectly :
Procedure without OUT parameter :

create or replace
PROCEDURE ADDFILEIN (SourceId IN NUMBER, 
                    SourceType IN VARCHAR2, 
                    FileName IN VARCHAR2, 
                    Folder IN VARCHAR2) 
IS

BEGIN
INSERT INTO FILEIN(FILEINSOURCEID, FILEINSOURCETYPE, FILEINNAME, FILEINFOLDER) VALUES (SourceID, SourceType, FileName, Folder);

END ADDFILEIN;

But when I change my procedure with an OUT parameter like this :

create or replace
PROCEDURE ADDFILEIN (SourceId IN NUMBER, 
                    SourceType IN VARCHAR2, 
                    FileName IN VARCHAR2, 
                    Folder IN VARCHAR2
                    FileId OUT NUMBER) 
IS

BEGIN
INSERT INTO FILEIN(FILEINSOURCEID, FILEINSOURCETYPE, FILEINNAME, FILEINFOLDER) VALUES (SourceID, SourceType, FileName, Folder)
RETURNING FILEINID INTO FileId;

END ADDFILEIN;

It doesn't work!
So I would like to know how can I retrive the value of the OUT parameter and put it in a variable context or anything else to be usable into my job.

topic tOracleRow and variable context in Talend Studio

tOracleRow and variable context