tOracleSP - Calling a function returning a recordset

Highlighted
One Star

tOracleSP - Calling a function returning a recordset

Hi all,
I'm using tOracleSp component to call Oracle functions.
Some of my Oracle functions return a recordset. In the tOracleSP, there is no 'RECORD SET' DB type for the returned value of a function ('RECORD SET' is only available in the output parameter of a store procedure).
The returned value must be map the the oracle.jdbc.OracleTypes.CURSOR java type.
To be able to use tOracleSp with functions that returns 'RECORD SET' (cursor), I crete my own tOracleSP component from the standard Talend tOracleSP component adn adapt it to be able to accept 'RECORD SET' as the DB type of the returned value of a function (see figure)
Note: AUTO MAPPING as DBtype doesn't match (mapped to java.sql.Types.OTHER : this failed at runtime).
In a future release of Talend products, could it be possible to add the 'RECORD SET' DB type as type of an oracle function , in the Talend tOracleSP component ?

Regards,
Community Manager

Re: tOracleSP - Calling a function returning a recordset

Hi
Can you please report a issue on our bugtracker?
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tOracleSP - Calling a function returning a recordset

One Star

Re: tOracleSP - Calling a function returning a recordset

Hi,
I have similar requirement where function returns the resultset..Is this added or we have to create custom component?

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads