aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

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
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.

请先 登录 后评论

1 个回答

小智
PLS-00422:没有为此绑定变量提供的绑定类型的PL / SQL翻译,
.原因:主机变量(通过Oracle预编译器程序)传递到PL / SQL进行绑定。但是,它的数据类型与任何PL / SQL数据类型不兼容。所以绑定失败了。,
.操作:更改主机变量的数据类型,使其与PL / SQL数据类型兼容。,
.
请先 登录 后评论