Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

More Oracle Errors Interview Questions

RMAN-08113: including current SPFILE in backupset

1 Answers  


IMP-00011: formatted table data not currently supported

1 Answers  


ORA-07269: spdcr: detached process died after exec.

1 Answers  


TNS-00112: Failed to find configuration file name

1 Answers  


QSM-01031: materialized view, string, is stale in TRUSTED integrity mode

1 Answers  






ORA-01616: instance string (thread string) is open - cannot disable

1 Answers  


ORA-13412: invalid scale parameter

1 Answers  


ORA-30046: Undo tablespace string not found in controlfile.

1 Answers  


TNS-00209: Tracing : string

1 Answers  


PCC-00056: FOR clause not allowed on SELECT statement at line number in file string.

1 Answers  


ORA-38749: A media recovery has been started.

1 Answers  


ORA-00962: too many group-by / order-by expressions

1 Answers  






Categories