Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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,