Which Component to use if the Oracle SQL has Package involved

[Anonymous]

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]

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

[manodwhb · Accepted solution]

@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]

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.