Declare
 Cursor C1 Is
  Select Emp_Comp_Code,Emp_Code,Emp_Name,Emp_Join_Dt
  From Asg_Sm_Emp_Key
  Where Emp_Comp_Code ='001'
  And Nvl(Emp_End_Of_service_Yn,'N') ='N'
  Order By To_Number(Emp_Code);

 Cursor C2 (Emp_Join_Dt In Date) Is
  Select Years,Trunc(Mb-Years*12)Months,Nd-Add_Months(Od,Trunc(MB))Days
	From
    (Select Od,Nd,Months_Between(Nd,Od) Mb,Trunc(Months_Between(Nd,Od)/12) Years
    (select Sysdate Nd,Sysdate-fd Od From
	(Select (Trunc(sysdate) - (:Emp_Join_Dt)) Fd From Dual)));
C2_Row C2%Rowtype;


Begin
 For I In C1 Loop
  IF C2%Isopen Then Close C2; End If;
    Open C2(I.Emp_Join_Dt);
      Loop
       Fetch C2 Into C2_Row;
	   Exit When C2%Notfound;
  	    Insert Into Temp_Test (Comp_Code,Emp_Code,Emp_Name,Dt_Date,Nu_Year,Nu_Mon
        Values (I.Emp_Comp_Code,I.Emp_Code,I.Emp_Name,Sysdate,C2_Row.Years,C2_Ro
	  End Loop;
    Close C2;
 End Loop;
End;
ORA-01008: not all variables bound

(Select (Trunc(sysdate) - (:Emp_Join_Dt)) Fd From Dual)));

(Select (Trunc(sysdate) - (Emp_Join_Dt)) Fd From Dual)));

ORA-01008 not all variables bound


Cause: A SQL statement containing substitution variables was executed without all variables bound. All substitution variables must have a substituted value before the SQL statement is executed. 

Action: In OCI, use an OBIND or OBINDN call to substitute the required values.