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.
