PLS-00250: Incorrect Usage of string in parameters clause.
- 1 Answers
- 2236 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-19564: error occurred writing string bytes at block number string
ORA-31201: DBMS_LDAP: generic error: string
ORA-13853: Tracing for service (module/action) string is already enabled
ORA-02729: osncon: driver not in osntab
ORA-07431: fork failed
ORA-19615: some files not found in backup set
NZE-29190: Multiple entries in OID
ORA-33078: (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.
ORA-13914: Threshold notification failed.
ORA-13138: could not determine name of object string
ORA-07860: osnsoi: error setting up interrupt handler
PCC-02451: Value of offset cannot be negative in ABSOLUTE orientation mode
Oracle Errors 
