Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00499: coercion into collection of records not supported
- 1 Answers
- 2714 Views
- I also Faced
- E-Mail Answers
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 |
NNL-00288: No cache flush currently scheduled
TNS-00512: Address already in use
ORA-06130: NETTCP: host access denied
LPX-00317: undefined decimal-format "~S"
ORA-09791: slembdf: translation error, unable to translate error file name.
NID-00133: Database should have only consistent datafiles
RMAN-20206: log sequence not found in the repository
ORA-03233: unable to extend table string.string subpartition string by string in tablespace string
SQL*Loader-00963: Error clearing user-side Ctrl-C handler
RMAN-06416: PROXY ONLY was specified and some files could not be proxy copied
ORA-16775: Target standby in switchover operation has missing redo logs.
ORA-26080: file "string" is not part of table string.string partition string
Oracle Errors 
