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

PLS-00361: IN cursor 'string' cannot be OPEN'ed

1 Answers  


ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

1 Answers  


DRG-50857: oracle error in string

1 Answers  


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

1 Answers  


ORA-29824: operator is invalid

1 Answers  


TNS-00257: Number of Successful Requests : number

1 Answers  


ORA-09826: SCLIN: cannot initialize atomic latch.

1 Answers  


ORA-28658: This operation is supported only for Index-Organized tables

1 Answers  


ORA-15182: ASMLIB [string] version mismatch, oracle version [string]

1 Answers  


QSM-02143: SUM(expr) without COUNT(expr)

1 Answers  


ORA-09941: Version of orapasswd or installer is older than file.

1 Answers  


RMAN-06595: platform name 'string' does not match database platform name 'string'

1 Answers  


Categories