代買如下：游標在程序中執行為44條資料，但把select拉出來直接運行有45條資料，確認后45條資料是正確的，請問下是什么原因，如何解決呢？
CURSOR Cur_Per_Info(v_Depart_Id IN Number) Is
Select asg.PERSON_ID
From Per_Assignments_F2 Asg,
Pay_Payroll_Actions Pac,
Pay_Assignment_Actions Aac
Where 1 = 1
And Pac.Payroll_Action_Id = Aac.Payroll_Action_Id
And Aac.Assignment_Id = Asg.Assignment_Id
And Asg.Payroll_Id = Pac.Payroll_Id
And p_period_name Between
To_Char(Asg.Effective_Start_Date, 'yyyy-mm') And
To_Char(Asg.Effective_End_Date, 'yyyy-mm')
And Pac.Action_Type = 'R'
And To_Char(Pac.Effective_Date, 'yyyy-mm') = p_period_name
And asg.ORGANIZATION_ID = v_Depart_Id
And Asg.Primary_Flag = 'Y'
And Pac.Payroll_Id = 61
Order By Aac.Payroll_Action_Id Asc, Aac.Assignment_Action_Id Asc;
uj5u.com熱心網友回復：
把你少的那條拿出來看看。大概問題應該出在 And asg.ORGANIZATION_ID = v_Depart_Id 這個條件上。
把 Per_Assignments_F2 的建表陳述句發上來。
uj5u.com熱心網友回復：
對照一下兩邊的結果，把遺失的那條記錄找出來。然后逐個條件篩選，檢查是哪個條件過濾了該記錄
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/57083.html
標籤：開發