Return record set from tOracleSP

Anonymous — Tue, 28 Aug 2012 14:00:13 GMT

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

Re: Return record set from tOracleSP

Anonymous — Wed, 29 Aug 2012 13:03:00 GMT

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

topic Return record set from tOracleSP in Talend Studio

Return record set from tOracleSP

Re: Return record set from tOracleSP