topic Re: Error calling tOracleSP with out parameter is sys_refcursor in Talend Studio

Error calling tOracleSP with out parameter is sys_refcursor

Anonymous — Thu, 26 Nov 2015 16:13:18 GMT

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

Re: Error calling tOracleSP with out parameter is sys_refcursor

Anonymous — Fri, 27 Nov 2015 06:38:43 GMT

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

Re: Error calling tOracleSP with out parameter is sys_refcursor

Anonymous — Sun, 29 Nov 2015 06:06:31 GMT

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,

Re: Error calling tOracleSP with out parameter is sys_refcursor

Anonymous — Wed, 02 Dec 2015 09:11:29 GMT

Hi. Sabrina. any news regarding this issue?

Thanks,

Re: Error calling tOracleSP with out parameter is sys_refcursor

Anonymous — Thu, 04 Feb 2016 11:46:21 GMT

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