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-27101: shared memory realm does not exist

1 Answers  


LFI-00108: Open expect the file [string][string] to exist.

1 Answers  


ORA-31199: Warning in processing file string

1 Answers  


PCC-00109: Dynamic SQL and PL/SQL are Oracle extensions to ANSI SQL

1 Answers  


ORA-14604: During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified

1 Answers  


DRG-12408: invalid variable reference: string.string

1 Answers  


ORA-16532: Data Guard broker configuration does not exist.

1 Answers  


ORA-07250: spcre: semget error, unable to get first semaphore set.

1 Answers  


ORA-09744: smsget: mmap returned an error.

1 Answers  


TNS-01045: %s(Not Registered) has string service handler(s)

1 Answers  


ORA-16547: cannot disable the primary database

1 Answers  


ORA-14068: TABLESPACE and TABLESPACE_NUMBER may not be both specified

1 Answers  


Categories