Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Parse oracle refcursor having select * statement

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.

Labels (3)
0 Replies