You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2013-12-06 10:24:30

earith
Member
2 posts

earith said:

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,
mini_123152_TalendSPRecordset.png

Last edited by earith (2013-12-06 10:32:12)

Offline

#2 2013-12-07 04:29:57

shong
Talend Team


shong said:

Re: tOracleSP - Calling a function returning a recordset

Hi
Can you please report a issue on our bugtracker?

Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!

Offline

#3 2013-12-09 10:06:17

earith
Member
2 posts

earith said:

Re: tOracleSP - Calling a function returning a recordset

Offline

#4 2014-07-01 20:22:30

krishnam503
Member
4 posts

krishnam503 said:

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?

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy