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...


PLS-00499: coercion into collection of records not supported



PLS-00499: coercion into collection of records not supported..

Answer / guest

Cause: A SELECT or FETCH may specify a column list to be
coerced into a variable which is a collection of records.
This is type checked as correct, but not yet supported
because of the implicit layout change required.

Action: Express the SELECT with an object constructor around
the columns and use a collection of objects as an INTO
variable. Or, build the collection one row at a time
coercing each row into a record which happens to be an
element. Or, use a record of collections.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09701: scnfy: maximum number of processes exceeded

1 Answers  


IMG-00808: unable to read an empty image

1 Answers  


ORA-21614: constraint violation for attribute number [string]

1 Answers  


PLS-01458: The set clause in an UPDATE statement requires a column name of length 1

1 Answers  


ORA-30945: Could not create mapping table 'string'

1 Answers  


AMD-00117: input file "string" not found

1 Answers  


RMAN-08119: skipping backup piece handle string; already exists

1 Answers  


RMAN-00574: rman aborting due to errors read/writing dbms_pipe

1 Answers  


ORA-02809: Jump buffer not valid

1 Answers  


ORA-12030: cannot create a fast refresh materialized view

1 Answers  


TNS-02526: server proxy type does not match client type

1 Answers  


ORA-32005: error while parsing size specification [string]

1 Answers  


Categories