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

LSX-00258: invalid escape character

1 Answers  


ORA-09798: Label comparison failed.

2 Answers  


ORA-30488: argument should be a function of expressions in PARTITION BY

1 Answers  


ORA-00312: online log string thread string: 'string'

1 Answers  


TNS-12558: TNS:protocol adapter not loaded

1 Answers  


ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>

1 Answers  


AMD-00120: dimension #string: analytic workspace dimension name not specified

1 Answers  


ORA-12217: TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA

1 Answers  


QSM-02181: a SPREADSHEET clause is present

1 Answers  


ORA-19703: device command string exceeds maximum length of string

1 Answers  


DRG-12404: more than one template string found

1 Answers  


TNS-01030: The listener supports no services

1 Answers  


Categories