PLS-00422: no PL/SQL translation for the bindtype given for
this bind variable



PLS-00422: no PL/SQL translation for the bindtype given for this bind variable..

Answer / guest

Cause: A host variable was passed (by an Oracle Precompiler
program, for example) to PL/SQL for binding. However, its
datatype is not compatible with any PL/SQL datatype. So, the
binding failed.

Action: Change the datatype of the host variable to make it
compatible with a PL/SQL datatype.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06911: CMX: t_event returns ERROR

1 Answers  


O2F-00303: No INTYPE file was specified

1 Answers  


ORA-39752: redundent column in partitioning and join columns is not allowed

1 Answers  


ORA-13389: unable to compute buffers or intersections in analysis function

1 Answers  


SQL*Loader-00113: Invalid silent mode option

1 Answers  






ORA-38460: filtering based on datatype "string" not supported for XML Tags

1 Answers  


ORA-32773: operation not supported for smallfile tablespace string

1 Answers  


ORA-03252: initial extent size not enough for LOB segment

1 Answers  


ORA-30337: multiple JOIN KEY clauses specified for the same parent level

1 Answers  


AUD-00704: invalid input format

1 Answers  


ORA-29853: keyword UNIQUE may not be used in creating domain indexes

1 Answers  


ORA-31452: invalid value string for parameter, expecting: Y or N

1 Answers  


Categories