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 or SQL formal parameter types. PL or 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 or SQL formal declaration i.e NUMBER, BINARY_INTEGER or PLS_INTEGER

No comments:

Post a Comment