Parse oracle refcursor having select * statement

Anonymous — Sat, 16 Nov 2024 03:15:35 GMT

Hi,

There is oracle stored procedure, with output (OUT) returning refcursor value.

Refcursor defined in Stored procedure:
Open p_ref_cursor for select * from table_a;

Used toraclesp to call this procedure, with record set option and stored it in a column/schema defined with object type.

Unable to parse the output of toraclesp component using tparseRecordSet component

tparserRecordSet doesnot return any output and says 0 recods parsed.
Verified the storeprocedure in database and it has more than 1000 records

Please advise how to parse the output.

topic Parse oracle refcursor having select * statement in Talend Studio

Parse oracle refcursor having select * statement