ORA-1458：变量字符串内的长度无效，ORA-01483：DATE或NUMBER绑定变量的长度无效 [英] ORA-1458 : invalid length inside variable character string, ORA-01483: invalid length for DATE or NUMBER bind variable

问题描述

我们一直在尝试解决一个问题。我们目前处于从11g到12c的oracle版本升级（RMS12应用程序）的中间，包括表单和报告。我们注意到一些非常奇怪的行为在某些形式中，即每当我们从表单执行某些更新或插入操作时，我们会得到ora-01458和ora-01483 errors.Strange的事情是这些错误不会发生在较低版本的11g中。



任何输入都将不胜感激！



谢谢



我尝试了什么：



我们已经尝试通过表单查找任何数据缓冲区长度问题但是因为它工作正常oracle 11g我们怀疑它可能与数据库级别的缓冲区大小有关

we have been trying to solve an issue for quite sometime now.We are currently in the middle of an oracle version upgrade(RMS12 application) from 11g to 12c including forms and reports as well.We have been noticing some very strange behaviour in some of the forms,that is whenever we perform some update or insert operation from the form we get ora-01458 and ora-01483 errors.Strange thing is that these errors doesn't occur in the lower version 11g.

Any input will be appreciated!

Thanks

What I have tried:

We have tried going through the form to find any data buffer length issues but the since it works fine in oracle 11g we suspect that it might be related to buffer size on a database level

推荐答案

请按照以下方法解决您的问题：

ORA -01458：变量字符串提示内的长度无效 [ ^ ]

ORA-01483：DATE或NUMBER绑定变量的长度无效 [ ^ ]

Follow these to resolve your issue:
ORA-01458: invalid length inside variable character string tips[^]
ORA-01483: invalid length for DATE or NUMBER bind variable[^]

这篇关于ORA-1458：变量字符串内的长度无效，ORA-01483：DATE或NUMBER绑定变量的长度无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！