One Star

Return record set from tOracleSP

Hi, I am trying to retrieve a record set via the stored procedure rather than a tOracleInput
Here is my sp
PROCEDURE GetLatAndLongs(recordset out SYS_REFCURSOR)
AS
BEGIN
GetLastRunDate('WeatherData', rundate);
UpdateStartTime('WeatherData');
open recordset FOR
SELECT DISTINCT round(latitude,2), round(longitude,2)
FROM locationhistory
where readingdate >= RUNDATE;
UpdateEndTime('WeatherData');
END GetLatAndLongs;
I've attached a screen print of how the tOracleSP is set up.
Thanks
1 REPLY
Community Manager

Re: Return record set from tOracleSP

Hi
After returning a recordset, you can use a tParseRecordSet component to parse the recordset, here is an example job:
http://www.talendforge.org/forum/viewtopic.php?id=7942
----------------------------------------------------------
Talend | Data Agility for Modern Business