PLS-00250: Incorrect Usage of string in parameters clause.



PLS-00250: Incorrect Usage of string in parameters clause...

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

Post New Answer

More Oracle Errors Interview Questions

RMAN-06583: at least 1 channel of TYPE DISK must be allocated to use AS COPY option

1 Answers  


ORA-16636: the object is permanently disabled

1 Answers  


IMP-00047: unexpected file sequence number; expected number but found number

1 Answers  


ORA-36735: A value exceeded the MAX specification

1 Answers  


DRG-50868: failed to free statement handle

1 Answers  






ORA-25187: specified exceptions table form incorrect

1 Answers  


LPX-00661: Failed to load: '~s'.

1 Answers  


ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor

1 Answers  


NNL-00287: Cache flush occurs in string

1 Answers  


NCR-04015: NCRR: Invalid interface name

1 Answers  


LSX-00284: duplicate constraint name "~S"

1 Answers  


SQL*Loader-00108: Invalid number of logical records to load

1 Answers  


Categories