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-13211: failed to tessellate the window object

1 Answers  


ORA-38493: feature not enabled : Expression Filter index

1 Answers  


ORA-32159: Cannot set prefetch options for a null Type

1 Answers  


ORA-09856: smpalo: vm_allocate error while allocating pga.

1 Answers  


ORA-13227: SDO_LEVEL values for the two index tables do not match

1 Answers  






ORA-22872: OID INDEX clause not allowed on tables with primary key based object identifiers

1 Answers  


ORA-29506: invalid query derived from USING clause

1 Answers  


NZE-29162: Non-FIPS cipher suites being used in FIPS mode.

1 Answers  


ORA-01902: SEGMENT keyword expected

1 Answers  


ORA-14634: Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table

1 Answers  


ORA-29815: object being associated is not present

1 Answers  


ORA-02214: duplicate BACKUP option specification

1 Answers  


Categories