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-31505: cannot alter or drop predefined change set

1 Answers  


RMAN-06487: changed proxy copy expired

1 Answers  


LSX-00283: referenced notation "~S" is not defined

1 Answers  


ORA-04099: trigger 'string' is valid but not stored in compiled form

1 Answers  


NNL-00347: Save_config_on_stop is now OFF

1 Answers  


ORA-08181: specified number is not a valid system change number

1 Answers   HCL,


NID-00401: Must finish REVERT changes before attempting any database operation.

1 Answers  


ORA-23473: replication RPC processing for "string"."string" is disabled

1 Answers  


NNF-04008: Error writing outputfile

1 Answers  


PCC-02310: formal parameter VARCHARs should be declared as pointers

1 Answers  


ORA-28171: unsupported Kerberos version

1 Answers  


DRG-10306: server terminated unexpectedly while processing command

1 Answers  


Categories