How to fix the Oracle error PLS-00400: different number of columns between cursor SELECT statement and return value?

In this post, you’ll learn more about the Oracle ErrorPLS-00400: different number of columns between cursor SELECT statement and return value with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00400: different number of columns between cursor SELECT statement and return value

Reason for the Error PLS-00400: different number of columns between cursor SELECT statement and return value

In a cursor declaration, a return type (such as RETURN emp%ROWTYPE) was specified, but the number of returned column values does not match the number of select-list items.

How to fix the Error PLS-00400: different number of columns between cursor SELECT statement and return value ?

You can fix this error in Oracle by following the below steps

Change the cursor return type or the select list so that the number of returned column values matches the number of select-list items.