PLW-07202: bind type would result in conversion away from
column type



PLW-07202: bind type would result in conversion away from column type..

Answer / guest

Cause: The column type and the bind type do not exactly
match. This will 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 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.

1 Answers  


DRG-10755: %(1)s and string have characters in common

1 Answers  


LSX-00310: local element or attribute should be namespace qualified

1 Answers  


ORA-30106: reserved for future use

1 Answers  


ORA-38304: missing or invalid user name

1 Answers  


UDI-00002: invalid username or password

1 Answers  


NNL-00986: Reforwarded requests expired: number

1 Answers  


LSX-00130: attribute "processContents" has invalid value "~S"

1 Answers  


ORA-29830: operator does not exist

1 Answers  


QSM-01081: no primary key or row id found for table, string, in MV, string

1 Answers  


LPX-00413: loss of precision due to excessively large numerical constant

1 Answers  


DRG-12402: error processing template string, line string

1 Answers  


Categories