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

ORA-09988: error while detaching SGA

1 Answers  


ORA-07425: sdpri: error string in translating dump file location.

1 Answers  


LSX-00272: BASE64-encoded binary grouped improperly (not 4's)

1 Answers  


ORA-31033: Requested number of XML children string exceeds maximum string

1 Answers  


ORA-22970: name does not correspond to an object view

1 Answers  






ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.

1 Answers  


PCC-02405: Variable is of undefined type

1 Answers  


TNS-00222: -------------------------------------------------------------------

1 Answers  


ORA-32153: Environment not specified

1 Answers  


ORA-39136: cannot specify an SCN on a transportable job

1 Answers  


TNS-00004: INTCTL: error while starting the Navigator

1 Answers  


ORA-13116: [string]_FACE$ table does not exist

1 Answers  


Categories