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

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

Question Posted / guest

1 Answers
3693 Views
I also Faced
E-Mail Answers

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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer