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

oracle

PLS-00400: different number of columns between cursor SELECT statement and return value
Cause: 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.
Action: Change the cursor return type or the select list so that the number of returned column values matches the number of select-list items.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/