How to fix the Oracle error PLS-00258: constrained datatypes disallowed in CALL Specifications?

In this post, you’ll learn more about the Oracle ErrorPLS-00258: constrained datatypes disallowed in CALL Specifications with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00258: constrained datatypes disallowed in CALL Specifications

Reason for the Error PLS-00258: constrained datatypes disallowed in CALL Specifications

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

How to fix the Error PLS-00258: constrained datatypes disallowed in CALL Specifications ?

You can fix this error in Oracle by following the below steps

Use the unconstrained type for that PL/SQL formal declaration i.e NUMBER, BINARY_INTEGER or PLS_INTEGER