topic Re: Which Component to use if the Oracle SQL has Package involved in Talend Studio

Which Component to use if the Oracle SQL has Package involved

Anonymous — Mon, 01 Apr 2019 11:58:25 GMT

Hi All,

I have a Oracle SQL (includes Packages) ,which component should i use to extract the output from that SQL.

When i execute the SQL in SQL developer i can see the output but when i use the same in talend i am getting error (attaching the screen shot).

The component i have used is tDBInput >> tLogrow.

In tDBinput i am using the query.

manodwhb — Mon, 01 Apr 2019 12:00:59 GMT

@pabburi ,tOracleDBInput is component to read by using a sql.

manodwhb — Mon, 01 Apr 2019 12:04:47 GMT

@pabburi ,i believe could be issue at wro.segment1 "resource_service_item" can you change to single quote.

ex:- wro.segment1 'resource_service_item',

joearun4u — Mon, 01 Apr 2019 12:23:22 GMT

Hi Pabburi,

If you want to execute the query to fetch the resultset , use tOracleInput.

If you have already created the stored proc and you just need to execute, then go with tOracleSP.

Give Kudos if you found this reply is useful.