aiaiDBA

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

13718043309

010-86462881

ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.

ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
Cause: The user attempted to use NUMBER(Precision) or NUMBER(Precision, Scale) as the datatype in a definition for some object other than a DIMENSION or VARIABLE, such as a FORMULA or PROGRAM. This error can also be produced in cases where a NUMBER data type is not allowed at all.
Action: Use the NUMBER type without specifying a precision or scale. If a NUMBER data type is not allowed at all, this fix will only change the exception message to something more specific.

请先 登录 后评论

1 个回答

小智
ORA-34276:(MXDCL33)(Precision,Scale)参数只能与NUMBER变量或维度一起使用。,
.原因:用户尝试在除DIMENSION或VARIABLE之外的某些对象(如FORMULA或PROGRAM)的定义中使用NUMBER(精度)或NUMBER(精度,缩放)作为数据类型。在不允许NUMBER数据类型的情况下也可能产生此错误。,
.操作:使用NUMBER类型,而不指定精度或标度。如果根本不允许NUMBER数据类型,此修复程序将只会将异常消息更改为更具体的消息。,
.
请先 登录 后评论