PLS-00258: constrained datatypes disallowed in CALL
Specifications



PLS-00258: constrained datatypes disallowed in CALL Specifications..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NCR-01010: NCRS: Invalid network address length.

1 Answers  


ORA-07477: scgcmn: lock manager not initialized.

1 Answers  


ORA-03008: parameter COMPATIBLE >= string needed for string

1 Answers  


ORA-07254: spdcr: translation error while expanding ?/bin/oracle.

1 Answers  


ORA-30437: all job queue processes have stopped running

1 Answers  


ORA-00370: potential deadlock during kcbchange operation

1 Answers  


RMAN-06412: no proxy copy channel found

1 Answers  


ORA-12726: unmatched bracket in regular expression

1 Answers  


ORA-12004: REFRESH FAST cannot be used for materialized view "string"."string"

1 Answers  


PCC-00132: Indicator array size must not be less than its host variable

1 Answers  


ORA-30077: illegal casting between specified datetime types

1 Answers  


ORA-03002: operator not implemented

1 Answers  


Categories