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-31429: subscription has not been activated

1 Answers  


ORA-30393: a query block in the statement did not rewrite

1 Answers  


ORA-33223: (CMOVE03) You cannot move a session-only dimension value.

1 Answers  


ORA-26054: Direct Path Context prepared for a different mode than operation requested.

1 Answers  


ORA-22611: TDS version is not recognized

1 Answers  






ORA-30373: object data types are not supported in this context

1 Answers  


ORA-06526: Unable to load PL/SQL library

1 Answers  


ORA-28661: Object already has COMPRESS clause specified

1 Answers  


ORA-16200: Skip procedure requested to skip statement

1 Answers  


ORA-08434: raw data has invalid trailing sign

1 Answers  


IMP-00038: Could not convert to environment character set's handle

1 Answers  


LPX-00402: invalid axisname in the XSL file

1 Answers  


Categories