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


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-03276: duplicate ALLOCATE EXTENT option specification

1 Answers  


ORA-24340: cannot support more than 255 columns

1 Answers  


TNS-00123: Unable to perform a listen on configured ADDRESS(es)

1 Answers  


ORA-02082: a loopback database link must have a connection qualifier

1 Answers  


PROC-00019: Cannot create more subkeys for the key

1 Answers  






ORA-32145: Environment not specified

1 Answers  


ORA-01670: new datafile string needed for standby database recovery

1 Answers  


ORA-16156: LGWR archive log dependency not allowed if database is standby protected

1 Answers  


NNL-00807: Queries received, type SOA: number

1 Answers  


ORA-40207: duplicate or multiple function settings

1 Answers  


ORA-08310: sllfop: Bad value for recsize

1 Answers  


RMAN-08093: specifying current controlfile for proxy backup

1 Answers  






Categories