PLS-00258: constrained datatypes disallowed in CALL
Specifications
- 1 Answers
- 4063 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-30504: system triggers cannot have a FOR EACH ROW clause
ORA-31047: Could not retrieve resource data at path string
NNL-00414: Maximum response time: string
ORA-12319: database (link name string) is already open
NNL-00036: No records loaded
RMAN-06004: ORACLE error from recovery catalog database: string
NID-00306: Datafile string - no revert needed
ORA-14131: enabled UNIQUE constraint exists on one of the tables
NZE-28784: file name translation failure
ORA-06541: PL/SQL: compilation error - compilation aborted
PLS-00328: A subprogram body must be defined for the forward declaration of string.
NID-00115: Database should be mounted
Oracle Errors 
