PLS-00258: constrained datatypes disallowed in CALL Specifications

PLS-00258: constrained datatypes disallowed in CALL Specifications
Cause: A call specification for C or Java cannot have constraints on the PL/SQL formal parameter types. PL/SQL types which have have constraints are NATURAL, NATURALN, POSITIVE, POSITIVEN, SIGNTYPE, INTEGER, INT, SMALLINT, DECIMAL, NUMERIC, DEC This includes NOT NULL constraints from POSITIVEN, NATURALN
Action: Use the unconstrained type for that PL/SQL formal declaration i.e NUMBER, BINARY_INTEGER or PLS_INTEGER

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00258：CALL规范中禁止约束的数据类型,
.原因： C或Java的调用规范不能对PL / SQL形式参数类型有约束。具有约束的PL / SQL类型是NATURAL，NATURALN，POSITIVE，POSITIVEN，SIGNTYPE，INTEGER，INT，SMALLINT，DECIMAL，NUMERIC，DEC这包括来自POSITIVEN，NATURALN的NOT NULL约束,
.操作：对该PL / SQL正式声明使用无约束类型，即NUMBER，BINARY_INTEGER或PLS_INTEGER,
.

aiaiDBA

13718043309

010-86462881

PLS-00258: constrained datatypes disallowed in CALL Specifications

1 个回答

相似问题