Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-06138: NETTCP: error during connection handshake

1 Answers  


ORA-06401: NETCMN: invalid driver designator

1 Answers  


NCR-03019: NCRO: Unable to initialize thread support

1 Answers  


ORA-09213: slgfn: error fabricating file name

1 Answers  


ORA-38464: expression set is not empty.

1 Answers  






RMAN-08008: channel string: starting full datafile backupset

1 Answers  


ORA-39113: Unable to determine database version

1 Answers  


ORA-00212: block size string below minimum required size of string bytes

1 Answers  


ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals

1 Answers  


NNL-00579: _scan: find objects/records matching the given types

1 Answers  


TNS-12590: TNS:no I/O buffer

1 Answers  


ORA-30457: 'string.string' cannot be refreshed because of unmnanaged NOT NULL columns in container

1 Answers  






Categories