How to call Oracle Package in Talend

SK1694344715 — Fri, 15 Nov 2024 21:20:32 GMT

Hi All,

Please provide detailed steps to call oracle package with procedure written inside it.

Also, we have written procedure in such a way that taking common records across multiple tables.

If we use packagaename.procedure name in tDBSP and provide tLogRow, whether we will receive data?

i want to use tFixedInput(Passing 1 i/p col value)-->tDBSP(Passing same i/p col value & Result as Object)-->tMap(Mapping only Result object)-->tRecordSet(Passing required O/P col names mentioned in procedure)-->tLogRow

please confirm whether above transformation will work to retrieve data for provided i/p(tFixedInput) component.

topic How to call Oracle Package in Talend in Talend Studio

How to call Oracle Package in Talend