PLS-00258: constrained datatypes disallowed in CALL
Specifications
- 1 Answers
- 3557 Views
- I also Faced
- E-Mail Answers
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 |
ORA-08207: ora_addr: cannot open address file
TNS-00251: Failure in nstest:
DRG-50801: failed to parse cursor
ORA-14114: partitioned table cannot have column with object, REF, nested table, array datatype
ORA-32103: error from OCI call
QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based
PLS-00247: LIBRARY name must be specified
RMAN-08048: channel string: starting incremental level string datafile backupset
SQL*Loader-00271: Not a Parallel load. Table level OPTIONS statement ignored.
RMAN-08599: channel string: throttle time: string
NNL-00416: Last timestamp: number
ORA-04016: sequence string no longer exists
Oracle Errors 
