SQL*Plus (MOSC)

MOSC Banner

Getting error PLS-00386: type mismatch found at 'xxx' between FETCH cursor and INTO variables

in SQL*Plus (MOSC) 2 commentsAnswered ✓

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center