Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

LPX-00001: NULL pointer

1 Answers  


ORA-23485: Column group "string" must consist of a single numeric column only

1 Answers  


ORA-26681: command type not supported

1 Answers  


DRG-10306: server terminated unexpectedly while processing command

1 Answers  


KUP-04105: zoned decimal to number conversion caused overflow for string

1 Answers  






ORA-16050: destination exceeded specified quota size

1 Answers  


ORA-16606: unable to find property "string"

1 Answers  


NNL-01045: Errors writing data stream: number

1 Answers  


ORA-12810: PARALLEL_MAX_SERVERS must be less than or equal to string

1 Answers  


NNO-00804: Error: OCI_STILL_EXECUTE

1 Answers  


ORA-01183: cannot mount database in SHARED mode

1 Answers  


ORA-06262: NETNTT: nfconn() failed

1 Answers  






Categories