Getting error PLS-00386: type mismatch found at 'xxx' between FETCH cursor and INTO variables
Both fields are defined NUMBER(5,2)
ORA-06550: line 159, column 4:
PLS-00386: type mismatch found at 'V_CHARGE_HOURS' between FETCH cursor and INTO variables
ORA-06550: line 151, column 7:
INPUT TABLE BEING READ IN THE CURSOR
DESCRIBE TLW.WEEKLY_PAYROLL_ENTRIES
Name Null Type
------------- ---- ------------
PAY_GROUP VARCHAR2(3)
BADGE_NUMBER NUMBER(8)
PEOPLESOFT_ID NUMBER(10)
CHARGE_CODE VARCHAR2(3)
SHIFT VARCHAR2(1)
DRUG_POOL VARCHAR2(1)
LABOR_GRADE VARCHAR2(4)
CHG_HOURS NUMBER(5,2)
PAY_DATE DATE
EARNINGS NUMBER(7,2)
ACCOUNT_CD VARCHAR2(25)
PROCESS_FLAG VARCHAR2(1)
FETCH INTO FIELDS:
---------------------------------------------------------------------
------ EMPLOYEE PAYROLL RECORDS ----------
---------------------------------------------------------------------
V_PAY_GROUP VARCHAR2(3);
V_BADGE_NUMBER VARCHAR2(8);
V_PEOPLESOFT_ID VARCHAR2(6);
V_CHARGE_CODE VARCHAR2(3);