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

PLS-00139: duplicate external NAME specification in subprogram expression

1 Answers  


PLS-00314: TABLE declarations are not allowed as PL/SQL local variables

1 Answers  


TNS-00006: INTCTL: HOST variable is not defined

1 Answers  


ORA-04003: sequence parameter string exceeds maximum size allowed (string digits)

1 Answers  


ORA-31109: Action failed as parent resource string is locked

1 Answers  


LCD-00203: missing keyword [string]

1 Answers  


PLS-00168: duplicate modifier specification 'string'

1 Answers  


TNS-01410: Service "string" has number instances.

1 Answers  


ORA-33072: (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.

1 Answers  


ORA-06044: NETDNT: connect failed, byte count quota exceeded

1 Answers  


ORA-01257: cannot reuse database file string, unknown file size

1 Answers  


ORA-01490: invalid ANALYZE command

1 Answers  


Categories