Return record set from tOracleSP

[Anonymous]

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

[Anonymous]

Hi
After returning a recordset, you can use a tParseRecordSet component to parse the recordset, here is an example job:
https://community.talend.com/t5/Design-and-Development/resolved-use-of-tsybasesp/td-p/106446