PLW-07204: conversion away from column type may result in
sub-optimal query plan
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-12537: TNS:connection closed
2 Answers State Bank Of India SBI,
SQL*Loader-00430: NULL nested table element is not allowed
ORA-26101: tablespace # in file header is string rather than string for file string
ORA-02093: TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)
PCB-00012: Command line option DYNAMIC=ANSI required with option TYPE_CODE=ANSI
ORA-09937: Chmod of ORACLE password file failed.
ORA-24389: Invalid scrollable fetch parameters
ORA-02337: not an object type column
ORA-07716: sksachk: invalid device specification for ARCHIVE
ORA-13423: invalid cell coordinate parameter
NNL-01063: Statistic counters next reset in: string
ORA-02298: cannot validate (string.string) - parent keys not found