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

NNL-00256: Server-generated requests now do not request forwarding

1 Answers  


TNS-00011: INTCTL: error while starting the Connection Manager

1 Answers  


QSM-00796: the specified SQL statement cannot be stored in the workload because table string does not have valid statistics

1 Answers  


ORA-27481: "string.string" has an invalid schedule

1 Answers  


ORA-12197: TNS:keyword-value resolution error

1 Answers  


ORA-12166: TNS:Client can not connect to HO agent.

1 Answers  


ORA-26525: session connection attempt failed for string (@string)

1 Answers  


DRG-50950: circular SQE found

1 Answers  


NID-00480: Database is intact - database is ready to be open or shut down.

1 Answers  


ORA-23458: inappropriate flavor string at string

1 Answers  


LPX-00116: element "~1S" attribute "~2S" has invalid value "~3S", must be "~4S"

1 Answers  


SQL*Loader-00267: Control file must be first data file.

1 Answers  


Categories