PLS-00401: different column types between cursor SELECT statement and return va

PLS-00401: different column types between cursor SELECT
statement and return value found at 'string'

Question Posted / guest

1 Answers
2227 Views
I also Faced
E-Mail Answers

PLS-00401: different column types between cursor SELECT statement and return value found at 's..

Answer / guest

Cause: In a cursor declaration, a return type (such as
RETURN emp%ROWTYPE) was specified, but a returned column
value and its corresponding select-list item have different
datatypes.

Action: Change the cursor return type or the select list so
that each returned column value and its corresponding
select-list item have the same datatype.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer