Error calling tOracleSP with out parameter is sys_refcursor

[Anonymous]

Hello.
I've created a procedure in Oracle:

create or replace procedure test_talend (id_ in integer, cur out sys_refcursor) is
begin
 OPEN cur FOR
 select * from TEST_TALEND;
end;

in Talend:
tOracleSP ==> tParseRecordSet ==> tLogRow

the tOracleSP schema contains one out parameter typed Object.
I get a java.sql.SQLException: Invalid column type: 1111

It's not even getting to tParseRecordSet...

any ideas?

Thanks

[Anonymous]

Hi,
Have you already checked KB article about: TalendHelpCenter:Calling a stored procedure or function?
Best regards
Sabrina

[Anonymous]

Hi, Sabrina.
Yes, I've checked that KB, and there is no example regarding a procedure with out parameters of type sys_refcursor, like in my example.
can you try to re-create the scenario?

Thanks, 

[Anonymous]

Hi. Sabrina. any news regarding this issue?

Thanks,

[Anonymous]

Hi,
I was wondering if there's any new regarding this issue. maybe in talend 6.0?
Thanks,