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-27039: create file failed, file size limit reached

1 Answers  


LSX-00281: referenced ID "~S" is not defined

1 Answers  


ORA-16792: Some configurable property value is inconsistent with the database setting.

1 Answers  


ORA-13190: recursive SQL fetch failed

1 Answers  


NNO-00601: warning: no forwarders, DEFAULT-FORWARDERS-ONLY mode ignored

1 Answers  


RMAN-06716: skipping datafile number; already restored to file string

1 Answers  


TNS-04206: Trace Assistant Internal ERROR: Packet Type

1 Answers  


ORA-14324: values being added already exist in DEFAULT partition

1 Answers  


ORA-06303: IPA: Message send error

1 Answers  


DRG-11704: phrase string does not exist

1 Answers  


ORA-02153: invalid VALUES password string

1 Answers  


ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)

1 Answers  


Categories