PLW-07204: conversion away from column type may result in
sub-optimal query plan
- 1 Answers
- 3591 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The column type and the bind type do not exactly
match. This may result in the column being converted to the
type of the bind variable. This type conversion may prevent
the SQL optimizer from using any index the column
participates in. This may adversely affect the execution
performance of this statement.
Action: To make use of any index for this column, make sure
the bind type is the same type as the column type.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 1 No |
ORA-13481: the destination type is not supported
ORA-12855: cannot run parallel or insert direct load in a loopback
ORA-23609: unable to find directory object for directory string
ORA-00377: Frequent backups of file string causing write operation to stall
ORA-08433: invalid picture type in convert raw to number
RMAN-06906: backup of controlfile was cancelled
ORA-01223: RESETLOGS must be specified to set a new database name
NZE-29155: continuous key pair consistency check self-test failure
RMAN-06197: Total System Global Area string bytes
RMAN-08529: proxy file handle=string
DRG-50858: OCI error: string
NNC-00050: message format error
Oracle Errors 
