Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-02359: internal error setting attribute string

1 Answers  


SQL*Loader-00473: nesting of collections is not allowed.

1 Answers  


ORA-02824: Request free list is empty

1 Answers  


ORA-25456: rule set was modified or evaluation terminated for iterator: string

1 Answers  


PCC-00015: Unrecognized Host Language syntax ignored at line number in file string

1 Answers  


ORA-07548: sftopn: Maximum number of files already open

1 Answers  


ORA-19206: Invalid value for query or REF CURSOR parameter

1 Answers  


NZE-29028: Server verification failure when using SSL 2.0

1 Answers  


PCC-02018: found end-of-file while scanning comment

1 Answers  


ORA-09293: sksasmo: unable to send message to console

1 Answers  


EXP-00035: QUERY parameter valid only for table mode exports

1 Answers  


ORA-09985: SGA definition file could not be read

1 Answers  


Categories