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

Oracle Error Message

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

Reason for the Error

The usage of Keywords such as MAXLEN, LENGTH, CHARSETID, CHARSETFORM RETURN in the parameters clause was incorrect

Solution

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);