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

NNO-00074: downloading region from server string

1 Answers  


SQL*Loader-00281: Warning: ROWS parameter ignored in parallel mode.

1 Answers  


PCC-00009: Invalid host variable at column number in line number of file string

1 Answers  


LSX-00222: "~1S" is too long (maximum length is ~2d)

1 Answers  


AMD-00106: parent string "string" must be removed before child string "string" can be removed

1 Answers  






ORA-38734: Flashback log is inconsistent; belongs to another database.

1 Answers  


ORA-31077: invalid attribute "string" specified

1 Answers  


IMP-00020: long column too large for column buffer size (number)

1 Answers  


ORA-25130: cannot modify primary key - primary key not defined for table

1 Answers  


LPX-00606: Missing attribute '~1s' in element '~2S'.

1 Answers  


ORA-32003: error occured processing parameter 'string'

1 Answers  


ORA-23485: Column group "string" must consist of a single numeric column only

1 Answers  


Categories