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-27411: An empty string is not a valid repeat interval.

1 Answers  


NNO-00257: warning: cannot get serial number from region store

1 Answers  


ORA-01489: result of string concatenation is too long

1 Answers  


NNO-00851: LDAP open/bind failed: error = number

1 Answers  


ORA-32843: value for string is outside the valid range of string to string

1 Answers  


QSM-01127: query rewritten with multiple MVs

1 Answers  


ORA-08448: syntax error in DECIMAL-POINT environment clause

1 Answers  


ORA-00036: maximum number of recursive SQL levels (string) exceeded

1 Answers  


NID-00353: string

1 Answers  


ORA-33056: (XSAGDNGL27) In AGGMAP workspace object, the MAX argument of number must be greater than the CEILING argument of number.

1 Answers  


ORA-16550: truncated result

1 Answers  


ORA-36160: (XSMXAGGR04) You may not use AGGREGATE on scalar VARIABLE workspace object.

1 Answers  


Categories