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

ORA-01890: NLS error detected

2 Answers  


ORA-12497: maximum combined categories exceeds string

1 Answers  


PCC-00146: Illegal value for host option, ignored

1 Answers  


QSM-01080: invalid dimension, string

1 Answers  


ORA-08319: sllfsk: Error reading file

1 Answers  






TNS-01093: %s * string * number

1 Answers  


DRG-13011: language column must be specified when using the multi lexer

1 Answers  


ORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted

1 Answers  


ORA-13510: invalid RETENTION string, must be in the range (string, string)

1 Answers  


PLS-00328: A subprogram body must be defined for the forward declaration of string.

1 Answers  


ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

1 Answers   CTS,


ORA-29957: cannot create a function-based domain index on a string table

1 Answers  


Categories