PLS-00250: Incorrect Usage of string in parameters clause.
- 1 Answers
- 2471 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The usage of Keywords such as MAXLEN, LENGTH,
CHARSETID, CHARSETFORM RETURN in the parameters clause was
incorrect
Action: This error occurs if keywords like MAXLEN, LENGTH,
TDO, DURATION, CHARSETID, or CHARSETFORM cannot be used with
PL/SQL formal parameters or the mode of the formal
parameter. For example, MAXLEN can only be declared for a
CHAR or VARCHAR2 PL/SQL variable and its use is allowed only
for OUT or INOUT PL/SQL variables. Also, RETURN was
specified in the parameters clause for a PL/SQL PROCEDURE.
E.g. CREATE PROCEDURE proc IS EXTERNAL NAME ... LIBRARY ...
PARAMETERS(RETURN INDICATOR SHORT, RETURN);
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-19571: %s recid string stamp string not found in controlfile
DRG-12400: template string is empty
LSX-00250: invalid normalizedString "~S"
RMAN-06223: starting up automatic instance string
ORA-36674: (XSDPART12) Invalid dimension value starting at string.
ORA-39026: master table is inconsistent on validation string
RMAN-04011: recovery catalog database Password:
ORA-01919: role 'string' does not exist
ORA-09878: sstascre/sstasat: shmat error, unable to attach tas write page
ORA-12200: TNS:could not allocate memory
ORA-07640: smsget: SGA not yet valid. Initialization in progress
PLS-00491: numeric literal required
Oracle Errors 
