Question

3
Replies
224
Views
Pavanir6 Member since 2016 103 posts
Amazon
Posted: 2 years ago
Last activity: 2 years 10 months ago
Closed

How to process a result set that is returned from postgresql functions in Pega

We have a stored from proc in Oracle as below

all PAYROLL.IDENTIFY_EMPLOYEES_Generic({.PayrollCountryISO3 in},{.PayrollRegRegion in},{.FormattedPayCycleStartDate in},{.FormattedPayCycleEndDate in},{.MinPrsnlInfoUnprcsdID out},{.MaxPrsnlInfoUnprcsdID out},{.MinNamesUnprcsdID out},{.MaxNamesUnprcsdID out},{.MinNationUnprcsdID out},{.MaxNationUnprcsdID out},{.MinPersDtUnprcsdID out},{.MaxPersDtUnprcsdID out},{.MinEmpAdrsUnprcsdID out},{.MaxEmpAdrsUnprcsdID out},{.MinEmailAdrsUnprcsdID out},{.MaxEmailAdrsUnprcsdID out},{.MinJobInfoUnprcsdID},{.MaxJobInfoUnprcsdID},{.MinJobUnprcsdID out},{.MaxJobUnprcsdID out},{.MinJobPayrollUnprcsdID out},{.MaxJobPayrollUnprcsdID out},{.MinJobCrntUnprcsdID out},{.MaxJobCrntUnprcsdID out},{.MinAddPayUnprcsdID out},{.MaxAddPayUnprcsdID out},{.Message out},{resultset})

Now same thing we are doing in postgresql as below

call PAYROLL.IDENTIFY_EMPLOYEES_Generic({.PayrollCountryISO3 in},{.PayrollRegRegion in},{.FormattedPayCycleStartDate in},{.FormattedPayCycleEndDate in},{.MinPrsnlInfoUnprcsdID out},{.MaxPrsnlInfoUnprcsdID out},{.MinNamesUnprcsdID out},{.MaxNamesUnprcsdID out},{.MinNationUnprcsdID out},{.MaxNationUnprcsdID out},{.MinPersDtUnprcsdID out},{.MaxPersDtUnprcsdID out},{.MinEmpAdrsUnprcsdID out},{.MaxEmpAdrsUnprcsdID out},{.MinEmailAdrsUnprcsdID out},{.MaxEmailAdrsUnprcsdID out},{.MinJobInfoUnprcsdID},{.MaxJobInfoUnprcsdID},{.MinJobUnprcsdID out},{.MaxJobUnprcsdID out},{.MinJobPayrollUnprcsdID out},{.MaxJobPayrollUnprcsdID out},{.MinJobCrntUnprcsdID out},{.MaxJobCrntUnprcsdID out},{.MinAddPayUnprcsdID out},{.MaxAddPayUnprcsdID out},{.Message out},{resultset})

select minprsnlinfounprcsdid as ".MinPrsnlInfoUnprcsdID", maxprsnlinfounprcsdid as ".MaxPrsnlInfoUnprcsdID", minnamesunprcsdid as ".MinNamesUnprcsdID", maxnamesunprcsdid as ".MaxNamesUnprcsdID", minnationunprcsdid as ".MinNationUnprcsdID", maxnationunprcsdid as ".MaxNationUnprcsdID", minpersdtunprcsdid as ".MinPersDtUnprcsdID", maxpersdtunprcsdid as ".MaxPersDtUnprcsdID", minempadrsunprcsdid as ".MinEmpAdrsUnprcsdID", maxempadrsunprcsdid as ".MaxEmpAdrsUnprcsdID", minemailadrsunprcsdid as ".MinEmailAdrsUnprcsdID", maxemailadrsunprcsdid as ".MaxEmailAdrsUnprcsdID", minjobinfounprcsdid as ".MinJobInfoUnprcsdID", maxjobinfounprcsdid as ".MaxJobInfoUnprcsdID", minjobunprcsdid as ".MinJobUnprcsdID", maxjobunprcsdid as ".MaxJobUnprcsdID", minjobpayrollunprcsdid as ".MinJobPayrollUnprcsdID", maxjobpayrollunprcsdid as ".MaxJobPayrollUnprcsdID", minjobcrntunprcsdid as ".MinJobCrntUnprcsdID", maxjobcrntunprcsdid as ".MaxJobCrntUnprcsdID", minaddpayunprcsdid as ".MinAddPayUnprcsdID", maxaddpayunprcsdid as ".MaxAddPayUnprcsdID", err_msg as ".Message", emps as resultset from PAYROLL.IDENTIFY_EMPLOYEES_Generic({.PayrollCountryISO3 in},{.PayrollRegRegion in},{.FormattedPayCycleStartDate in}::Date,{.FormattedPayCycleEndDate in}::Date)

But i am not gettingresult set. Can some one please suggest me how to proceed.

Data Integration
Moderation Team has archived post
Share this page LinkedIn