Problem:

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

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.

Calling a stored procedure with COMP variable. Using Oracle precompiler.

Resolution:

Ensure that the host variable definitions are suitable for the columns being used.

For example, with a host variable defined as PIC S9(13) COMP, this should be changed to either PIC S9(9) COMP for an integer field, or PIC S9(13) COMP-3 for a decimal-type field.