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.
