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,
Highlighted
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
Highlighted
One Star

Re: tOracleSP - Calling a function returning a recordset

Highlighted
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?

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog