ORA-32583: query passed to table function has wrong number
of elements in select list



ORA-32583: query passed to table function has wrong number of elements in select list..

Answer / guest

Cause: The query used as an input to a table function which
takes a a ref cursor as argument has wrong number of
elements in the select list which does not correspond to the
elements in ref cursor. The ref cursor mentioned here refers
to the one referenced in order by parition clauses. This is
not allowed.

Action: Make sure that the select list of the query matches
the ref cursor columns as defined in the function.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01526: error in opening file 'string'

1 Answers  


ORA-16208: Logical standby dictionary build failed to start.

1 Answers  


ORA-31691: The worker received message number string from the MCP, which is invalid.

1 Answers  


ORA-32060: channel failure

1 Answers  


DRG-50920: part of phrase not itself a phrase or equivalence

1 Answers  


ORA-25239: message ID not supplied when dequeuing from exception queue string.string

1 Answers  


RMAN-10004: unable to connect to recovery catalog

1 Answers  


PLS-00523: ORDER methods must return an INTEGER.

1 Answers  


PCC-02112: OBJECTS option ignored. OBJECTS=YES is not allowed for DBMS=V6 or V7.

1 Answers  


ORA-28276: Invalid ORACLE password attribute.

1 Answers  


QSM-01056: no query rewrite for this DDL expression

1 Answers  


TNS-00042: INTCTL: CMANAGER already running. Start operation cancelled

1 Answers  


Categories